Anaplan connect via JDBC with SQL DB (partial data loading)

Sivasankar
Contributor

Anaplan connect via JDBC with SQL DB (partial data loading)

Hi,

We are using Anaplan Connect 1.4 to load data into SQL database via JDBC conneciton. the export script when manually exports 2459 but when the export is triggered through Anaplan connect only partial data is getting loaded. Can someone suggest me what is going wrong here?

-

-

2021-01-26 13:06:16 INFO 216 |-- serverAlert - Completed successfully!
2021-01-26 13:06:16 INFO 216 |-- exportName - New EU Export
2021-01-26 13:06:20 INFO 216 |-- Export New EU Export to database started successfully
2021-01-26 13:06:20 INFO 216 |-- Created JDBC connection to: jdbc:sqlserver://.......;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;multiSubnetFailover=false;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=.......;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite;
2021-01-26 13:06:20 INFO 216 |-- Writing batch 1 (1000 records)
2021-01-26 13:06:20 INFO 216 |-- Batch 1 written (0 records committed,0 records errored out)
2021-01-26 13:06:20 INFO 216 |-- Writing batch 2 (1000 records)
2021-01-26 13:06:21 INFO 216 |-- Batch 2 written (1000 records committed,0 records errored out)
2021-01-26 13:06:21 INFO 216 |-- Writing batch 3 (459 records)
2021-01-26 13:06:21 INFO 216 |-- Batch 3 written (0 records committed,0 records errored out)
2021-01-26 13:06:21 INFO 216 |-- Transferred 1000 records to jdbc:sqlserver:

 

Regards,

Siva

2 REPLIES 2
MarkWarren
Expert

Re: Anaplan connect via JDBC with SQL DB (partial data loading)

Is this consistent every time?
Also, it has been a month since this post, did you resolve it?

In the JDBC connection string you could try packetSize -1 (but not sure this would affect anything here).

dsoomar002
Contributor

Re: Anaplan connect via JDBC with SQL DB (partial data loading)

Hi Siva,

 

This is an interesting issue you have brought up. Last year when I used to work in Support I recall seeing a similar case, though I don’t recall the solution. Can you try emailing support@anaplan.com? They will have access to the previous cases and may have similar reports that could help solve your issue of partial data loads