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