Troubleshooting
Problem
Unable to run a Table-only publish for one application when user annotations is selected. All other publishes for different applications are successful.
Symptom
Following error message displayed in the error details of the Job Management screen for the application:
"<SupplementalInfo><Source>EAdminSQL7_83.SQL7.CheckOutputForErrors</Sour
e><StackInfo><ErrorGuid>{288DFA5C-E839-41E4-BCF2-F5FCABBF1CFA}</ErrorGu
d><StackPosition>7</StackPosition><PreviousUserDomain>WATER</PreviousUs
rDomain><PreviousUserName>ServiceCognos</PreviousUserName><PreviousComp
terDomain>WATER</PreviousComputerDomain><PreviousComputerName>WSLDCTVCO
2</PreviousComputerName></StackInfo></SupplementalInfo>
Error Number: -2147220469
Line Number: 400
Description: Unable to execute Job Item
Unable to Bulk Load the data.
Error found in output.
Starting copy...
SQLState = 22018, NativeError = 0
Error = [Microsoft][SQL Native Client]Invalid character value for cast
specification
SQLState = 22018, NativeError = 0
Error = [Microsoft][SQL Native Client]Invalid character value for cast
specification
0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 10"
In the planningerrorlog.csv file, the following error is listed:
"Subscript out of range"
[{"Product":{"code":"SS9S5U","label":"Cognos 8 Planning"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSPN2D","label":"Cognos Planning"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
09 May 2025
UID
swg21414457