View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004950SymmetricDSBugpublic2021-04-15 04:242022-08-02 20:18
Reporterluiscamacho1412 Assigned To 
Priorityurgent 
Status newResolutionopen 
Product Version3.11.4 
Summary0004950: Error while queuing initial loads StackTraceKey.init [SqlException:942457291]
DescriptionHi
I'm getting this error in the replication from node 000 to 001

2021-04-15 04:14:41,826 INFO [replica] [InitialLoadService] [replica-job-12] Creating load request from node 001 to node 000
2021-04-15 04:14:42,545 INFO [replica] [InitialLoadService] [replica-job-12] Found 21 table reload requests to process.
2021-04-15 04:14:43,661 INFO [replica] [DataService] [replica-job-12] Queueing up an initial load to node 000
2021-04-15 04:14:45,215 ERROR [replica] [InitialLoadService] [replica-job-12] Error while queuing initial loads StackTraceKey.init [SqlException:942457291]
org.jumpmind.db.sql.SqlException: [Amazon](500310) Invalid operation: Cannot insert a NULL value into column data_id
Details:
 -----------------------------------------------
  error: Cannot insert a NULL value into column data_id
  code: 8007
  context: query execution
  query: 86094347
  location: column:1
  process: query5_126_86094347 [pid=9589]
  -----------------------------------------------;
        at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:305)
        at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:294)
        at org.jumpmind.db.sql.JdbcSqlTransaction.insertWithGeneratedKey(JdbcSqlTransaction.java:531)
        at org.jumpmind.symmetric.service.impl.DataService.insertData(DataService.java:1964)
        at org.jumpmind.symmetric.service.impl.DataService.insertDataAndDataEventAndOutgoingBatch(DataService.java:2071)
        at org.jumpmind.symmetric.service.impl.DataService.insertNodeSecurityUpdate(DataService.java:2140)
        at org.jumpmind.symmetric.service.impl.DataService.insertSqlEventsPriorToReload(DataService.java:1176)
        at org.jumpmind.symmetric.service.impl.DataService.insertReloadEvents(DataService.java:940)
        at org.jumpmind.symmetric.service.impl.InitialLoadService.processTableRequestLoads(InitialLoadService.java:243)
        at org.jumpmind.symmetric.service.impl.InitialLoadService.queueLoads(InitialLoadService.java:94)
        at org.jumpmind.symmetric.job.InitialLoadJob.doJob(InitialLoadJob.java:43)
        at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:227)
        at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:298)
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
        at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
        at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.sql.SQLException: [Amazon](500310) Invalid operation: Cannot insert a NULL value into column data_id

where replica is my 001 node.
Steps To Reproduceit is happening when the symmetric starts
Tagsdialect: redshift

Activities

josh-a-hicks

2021-04-21 17:59

developer   ~0001922

What database platform are you using?

luiscamacho1412

2021-04-22 02:34

reporter   ~0001924

Hello, i am using SqlServer as 000 and the 001 node is a Redshift cluster

Issue History

Date Modified Username Field Change
2021-04-15 04:24 luiscamacho1412 New Issue
2021-04-21 17:59 josh-a-hicks Note Added: 0001922
2021-04-22 02:34 luiscamacho1412 Note Added: 0001924
2022-08-02 20:18 elong Tag Attached: dialect: redshift