About Sivasankar

Hi Experts, We use Anaplan connect 1.4.4 to import data from SQL. we noticed that after import execution the file delimiter default itself to "Tab" even though it is set to "Comma" delimiter. this is weird.  Interesting part is even if the action changes from comma to tab further load using the same API call works when it was imported using Anaplan client 1.4.4 but this is not working when this action is called from AWS API (v2) @Echo off set ActionName="1.1 Current date upload from SQL" set ActionFile="Current_Date.csv" set JDBCFile=JDBC_Current_Date.properties set ErrorFile=Current_Date_Error.txt set Operation=-auth %AuthUrl% -file %ActionFile% -jdbcproperties "%JDBCpath%\%JDBCFile%" -import %ActionName% -execute -output "%Errorpath%\%ErrorFile%" rem *** End of settings - Do not edit below this line *** setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser% set Command=.\AnaplanClient.bat %Credentials% -workspace %DatahubWSID% -model %DatahubModelID% %Operation% cmd /c %Command% Action is configured as "Comma" delimiter After executing the API import, the delimiter automatically changes to "TAB" from "COMMA" Please suggest why delimiter changes after Anaplan connect 1.4.4 API call   Regards, Siva     ... View more

Hi Experts, Encountered an issue with selective access of list items. Our requirement is to provide selective access to Zone and in the dashboard users see information for their specific Zone rolled up @ Region. When selective access is provided to the Zone list items, the Region list is not displayed for the users (neither the rolled up data is not displayed for them for their specific zones) In the model, we have 2 list, list1 is  "Region" and list2 is "Zone". List1 is the parent of list2 and the hierarchy is built using this relationship (Region is the parent of Zone) Region List        Zone List A                         A (Zone1, Zone2, Zone3) where zone1..3 are list items and its parent is A B                        B (Zone4, Zone5, Zone6) where zone4..6 are list items and its parent is B C                        C (Zone7, Zone8) where zone7&8 are list items and its parent is C Provided selective access to user to Zone5 & Zone6 and this user need to see information of these 2 Zones at all pages. Region B need to show information of Zone5 & Zone6 and not all.  Problem statement: if NO selective access is provided for Region list then i could not bring a dashboard for the users to display data @ region level if selective access is provided to "Region" list then all zones (including Zone4 data is displayed) at region level Kindly guide us what access to be granted to the user to overcome these scenarios Regards, Siva   ... View more

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 ... View more

Hi Team, one of the export from Anaplan to SQL tables failing with the following error message. This script ran successfully till 27th Aug and it was failing for past 2 days. No changes were made and it was the same export script and JDBC properties file and same target table is being used. Appreciate for your guidance to narrow down the issue Error message: 2020-08-31 09:19:35 ERROR 3172 |-- Feign: Cannot deserialize value of type `com.anaplan.client.DataType` from String "TIME_ENTITY": not one of the values accepted for Enum class: [ENTITY, SUMMARY, BOOLEAN, NUMBER, MULTISELECT_HIERARCHY, MULTISELECT_ENTITY, DATE, MULTISELECT_USER, MULTISELECT_MODULE, FORMAT, NONE, MIXED, ACTION_DEFINITION, TEXT] at [Source: (BufferedReader); line: 11, column: 402] (through reference chain: com.anaplan.client.dto.responses.ExportMetadataResponse["exportMetadata"]->com.anaplan.client.dto.ExportMetadata["dataTypes"]->java.lang.Object[][40]) reading GET https://api.anaplan.com//2/0/workspaces/........... (Invalid format: Cannot deserialize value of type `com.anaplan.client.DataType` from String "TIME_ENTITY": not one of the values accepted for Enum class: [ENTITY, SUMMARY, BOOLEAN, NUMBER, MULTISELECT_HIERARCHY, MULTISELECT_ENTITY, DATE, MULTISELECT_USER, MULTISELECT_MODULE, FORMAT, NONE, MIXED, ACTION_DEFINITION, TEXT] at [Source: (BufferedReader); line: 11, column: 402] (through reference chain: com.anaplan.client.dto.responses.ExportMetadataResponse["exportMetadata"]->com.anaplan.client.dto.ExportMetadata["dataTypes"]->java.lang.Object[][40])) Regards, Siva ... View more

Hi, Greeting!!! In the new UX page, when a page is created and published, we get RESET link on top along with other filters. first what is the purpose of this "RESET" link and how to get rid of this link? Users are getting confused by this "RESET" link   Regards, Siva ... View more

Hi Experts,   Trying to export data from Anaplan to SQL using JDBC connection. the script was working good for my last export where i was able to export the data to SQL successfully. Approach is the same and with new export script now, Script was working good till export and i encounter 500 internal server error for new exports. API attempts to fetch the file (export id)  but fails   I used batch connection to export the data, export was successful and created the export ID. While exporting this file to database it fails as the referenced ID could not be fetched. API request is attempting to fetch that particular export id and ending up without result. After multiple attempts it prompts error (attached the batch execution screen)   Kindly explain why this unusual behavior and how to overcome this situation.   Note: i referred one another post for a similar issues but there was no solution. (that worked without any changes)   Regards, Siva ... View more