Troubleshooting
Problem
An error occurs committing data in PA for Excel.
Symptom
Error Message:
IBM Framework for Microsoft Office
Page 1(0) - AUSTRALIA
StringCellUpdateError (285)
StringCellUpdateError (285)
at Cognos.Office. Tm1.OData.Providers Commit Provider. Update(String server. String cube. Element commit. Cancellation Token token. IDictionary'2 properties)
at Cognos.Office.Tm1.OData. Providers. Commit Provider Update(Result Set result Set, String searchPath, IList'1 values. Cancellation Token token. IDictionary'2 properties)
at Cognos.Office.Reporting. Mapping.MapConnectionModel. Update(IResult Set result Set. IList '1 values. Cancellation Token token. IDictionary'2 properties)
at Cognos Office. Reporting. Mapping. ResultGenerator.UpdateNonNumeric_DoWork(MapUpdateEventArgs result, Cancellation Token token)
at Cognos. Office.Framework. Threading. Tasks.PoolTask'3.Invoke()
at Cognos.Office Framework. Threading. Tasks.AsyncTask.Run()
at Cognos.Office.Tm1.OData. Providers. Commit Provider Update(Result Set result Set, String searchPath, IList'1 values. Cancellation Token token. IDictionary'2 properties)
at Cognos.Office.Reporting. Mapping.MapConnectionModel. Update(IResult Set result Set. IList '1 values. Cancellation Token token. IDictionary'2 properties)
at Cognos Office. Reporting. Mapping. ResultGenerator.UpdateNonNumeric_DoWork(MapUpdateEventArgs result, Cancellation Token token)
at Cognos. Office.Framework. Threading. Tasks.PoolTask'3.Invoke()
at Cognos.Office Framework. Threading. Tasks.AsyncTask.Run()
Cause
There was a character in the data upload file that was string and not numeric.
Resolving The Problem
Corrected the uploaded data, ensuring data types matched.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m50000000KzLFAA0","label":"Planning Analytics-\u003EPlanning Analytics For Microsoft Excel-\u003EModel and Reporting"}],"ARM Case Number":"TS011841971","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
28 June 2023
UID
ibm17008317