cancel
Showing results for 
Search instead for 
Did you mean: 

INSERT INTO "BC_CTC_CTXSTORE" fails with SQL error state=22008.

former_member202208
Active Participant
0 Kudos

Hello Experts.

When i am trying to enable System Landscape Directory, the CTC execution is not success and it fails with the following popup.

I have executed other CTC tasks for other modules on this instance and i didn't see this issue before.

Netweaver version : 7.4

Am i missing any configuration?

Any help would be highly appreciated.

CTC Logs: Stack Trace

com.sap.tc.lm.ctc.exception.CTCException: Database operation error

  at com.sap.tc.lm.ctc.metamodel.process.controller.StoreContextControllerImpl.storeContexttoDB(StoreContextControllerImpl.java:131)

  at com.sap.tc.lm.ctc.metamodel.process.controller.StoreContextControllerImpl.execute(StoreContextControllerImpl.java:94)

  at com.sap.tc.lm.ctc.cul.serviceimpl.process.StoreContextControllerDefaultImpl.execute(StoreContextControllerDefaultImpl.java:58)

  at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741)

  at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

  at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741)

  at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

  at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741)

  at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

  at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741)

  at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

  at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessExecuter.run(ProcessExecuter.java:156)

  at java.lang.Thread.run(Thread.java:743)

Caused by: com.sap.tc.lm.ctc.exception.CTCException: Database operation error

  at com.sap.tc.lm.ctc.cul.persistence.ActionContextStoreDBImpl.storeContextWithExpTime(ActionContextStoreDBImpl.java:407)

  at com.sap.tc.lm.ctc.metamodel.process.controller.StoreContextControllerImpl.storeContexttoDB(StoreContextControllerImpl.java:129)

  ... 12 more

NW Log:

SQL error occurred on connection <SERVER>:<INST>:SAP<INST>DB: code=0, state="22008", message="One or more values is out of range of values for the datetime2 SQL Server data type";

SQL statement is "INSERT INTO "BC_CTC_CTXSTORE" ("SESSION_ID","CONTEXT","EXPIRY_TIME") VALUES (?,?,?)".

[EXCEPTION]

com.microsoft.sqlserver.jdbc.SQLServerException: One or more values is out of range of values for the datetime2 SQL Server data type

at com.microsoft.sqlserver.jdbc.TDSWriter.writeScaledTemporal(IOBuffer.java:4381)

at com.microsoft.sqlserver.jdbc.TDSWriter.writeRPCDateTime2(IOBuffer.java:4184)

at com.microsoft.sqlserver.jdbc.DTV$SendByRPCOp.sendTemporal(dtv.java:584)

at com.microsoft.sqlserver.jdbc.DTV$SendByRPCOp.execute(dtv.java:356)

at com.microsoft.sqlserver.jdbc.DTV.executeOp(dtv.java:1025)

at com.microsoft.sqlserver.jdbc.DTV.sendByRPC(dtv.java:1116)

at com.microsoft.sqlserver.jdbc.Parameter.sendByRPC(Parameter.java:660)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.sendParamsByRPC(SQLServerPreparedStatement.java:473)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doPrepExec(SQLServerPreparedStatement.java:628)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:400)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314)

at com.sap.sql.jdbc.basic.BasicPreparedStatement.executeUpdate(BasicPreparedStatement.java:108)

at com.sap.sql.jdbc.mss.MssInetPreparedStatement.executeUpdate(MssInetPreparedStatement.java:337)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeUpdate(DirectPreparedStatement.java:372)

at com.sap.sql.jdbc.common.CommonPreparedStatement.executeUpdate(CommonPreparedStatement.java:354)

at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:397)

at com.sap.tc.lm.ctc.cul.persistence.ActionContextStoreDBImpl.storeContextWithExpTime(ActionContextStoreDBImpl.java:402)

at com.sap.tc.lm.ctc.metamodel.process.controller.StoreContextControllerImpl.storeContexttoDB(StoreContextControllerImpl.java:129)

at com.sap.tc.lm.ctc.metamodel.process.controller.StoreContextControllerImpl.execute(StoreContextControllerImpl.java:94)

at com.sap.tc.lm.ctc.cul.serviceimpl.process.StoreContextControllerDefaultImpl.execute(StoreContextControllerDefaultImpl.java:58)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessExecuter.run(ProcessExecuter.java:156)

at java.lang.Thread.run(Thread.java:743


Thanks,


Accepted Solutions (0)

Answers (1)

Answers (1)

former_member202208
Active Participant
0 Kudos

Hello,


Did anyone face this issue? Whats the resolution?


Thanks,

Shridhar.

Former Member
0 Kudos

Hi Shridhar,

Did you cancel the configuration and tried the Reexecute open for the template? Run it again.

What is the release, patch for the system?

If the problem still exist, please raise an OSS message to BC-INS-CTC-RT. We will have a look into the issue.

Regards,

Manoj

former_member202208
Active Participant
0 Kudos

Hello Manoj,

Yes, I did cancel and retried a few time, each time i got the same message.

Netweaver version: 7.4

LMCTC 7.4.2

Let me know if you need any more information.

Thanks,

Shridhar

Former Member
0 Kudos

Hi Shridhar,

Have you checked the Tablespace sizes onyour database are they having sufficient space.

Also can you provide the details of the defaulttrace from your server node 0 or 1. So that we can try to get more details on the issue.

Regards,

Ram

Former Member
0 Kudos

Hi Shridhar,

Please raise an OSS message and open the connection to the system. We will check this further.

Regards,

Manoj

former_member202208
Active Participant
0 Kudos

Hello Manoj/Ram,

I will execute the task again and will update you on the logs.

Thanks,

Shridhar.

MehulAghera
Explorer
0 Kudos

Hello Manaj/Sridhar

Any Ref. Notes for this issue. Facing similar problem in our initial setup.

Thanks,

Mehul

former_member202208
Active Participant
0 Kudos

Hello Manoj/Ram,

I re-ran the CTC task and it worked.

@Mehul, Pls reboot your server and re-try.

Thanks,

Shridhar.