Troubleshooting
Problem
User schedules a published Data Mart. User checks the batch queue afterwards. There is an error message.
Symptom
Batch Queue:
<1234> Finished with Error Process Cube abcdef <date> etc. etc.
Double-click on this to see:
Details Section <1234>
Text
Error: Arithmetic overflow error converting IDENTITY to data type int.
Event Viewer on Application Server:
#1
Event Type: Warning
Event Source: VBRuntime
Event Category: None
Event ID: 1
Date: 14/02/2008
Time: 07:10:59
User: N/A
Computer: APPSERVER
Description:
The VB Application identified by the event source logged this Application FrSrvFunc: Thread ID: 2592 ,Logged: Error occured at 14/02/2008 8:10:59 in FrSrvFunc, Error No=-2147217833, Source=Server function:Dbp_ExecuteImmediate(..) , Description=Arithmetic overflow error converting IDENTITY to data type int., HelpFile= HelpContext=0
#2
Event Type: Warning
Event Source: VBRuntime
Event Category: None
Event ID: 1
Date: 14/02/2008
Time: 07:10:59
User: N/A
Computer: APPSERVER
Description:
The VB Application identified by the event source logged this Application FrSrvFunc: Thread ID: 2592 ,Logged: Error occured at 14/02/2008 8:10:59 in FrSrvFunc, Error No=-2147217833, Source=Server function:Dbp_InsertSqlRemote(..) , Description=Arithmetic overflow error converting IDENTITY to data type int., HelpFile= HelpContext=0
#3
Event Type: Warning
Event Source: VBRuntime
Event Category: None
Event ID: 1
Date: 14/02/2008
Time: 07:10:59
User: N/A
Computer: APPSERVER
Description:
The VB Application identified by the event source logged this Application FrSrvFunc: Thread ID: 2592 ,Logged: Error occured at 14/02/2008 8:10:59 in FrSrvFunc, Error No=-2147217833, Source=Server Sub:Db_PushSqlRemore(..) , Description=Arithmetic overflow error converting IDENTITY to data type int., HelpFile= HelpContext=0
#4
Event Type: Warning
Event Source: VBRuntime
Event Category: None
Event ID: 1
Date: 14/02/2008
Time: 07:10:59
User: N/A
Computer: APPSERVER
Description:
The VB Application identified by the event source logged this Application FrangoOLAPServer: Thread ID: 2592 ,Logged: Error occured at 14/02/2008 8:10:59 in FrOLAPServer, Error No=-2147217833, Source=FrOLAPServer.OlapNykomoT.GenerateValues#Server Sub:Db_PushSqlRemore(..) , Description=Arithmetic overflow error converting IDENTITY to data type int., HelpFile= HelpContext=0
Log InLog in to view more of this document
Historical Number
1038419
Was this topic helpful?
Document Information
Modified date:
08 May 2025
UID
swg21347703