Partition query is giving error during intial load in SLT

[former_member138885]

Hello All,

We have refreshed our QA system with prod DB. Getting the following error while starting the SLT replication after refresh for table CDPOS which is partitioned in Source & Taget systems.

sql syntax error:incorrect syntax near "ALTER":line 74 col 3 (at pos 1453)

creation of table CDPOS failed.

We have already maintained the partition query in LTRS-->Table settings as ALTER TABLE <schema name>.CDPOS PARTITION BY HASH (OBJECTID) PARTITIONS 8;

We are getting the same error for all the partitioned tables, rest of the tables loaded successfully.

We have tried by changing the partition command as PARTITION BY HASH (OBJECTID) PARTITIONS 8; still getting the same error.

Note:- We are able to replicate the same table with the same partition command in production environment.

Regards,

VM

[HakanHaslaman]

Did you already check the authorization like mention in the Security Guide?

[former_member138885]

Hi Hakan,

Thanks for your reply. There is no authorization issue.

Regards,

Vinay

[former_member138885 · Accepted solution]

Hi All,

We have resolved this issue by starting replication without partition command. Once the table is created in target system, we have partitioned the table before initial load started(during calculation jobs are running) & updated the table settings with partition query in LTRS.

Regards,

Vinay

[li_jin]

Hi Vinay,

The second partition command is correct.
If you can reload the table, try to reload it. If still doesn't work, try to run "Reset all Objects and settings for a table" from LTRC > Processing Steps to clear all the things for the table and then reset the configurations in LTRS, and replicate the table again.

As cluster tables are usually big, you can reference note 2735443 to parallel processing.

Thanks,

Li

[former_member138885]

Hi Li,

We have resolved this issue by starting replication without partition command. Once the table is created in target system, we have partitioned the table before initial load started(during calculation jobs are running) & updated the table settings with partition query in LTRS.

Regards,

Vinay