Error: Table has no entry in the ml_table table

[Former Member]

Hi Experts,

I am trying to insert(upload_insert) data into a table in HCP using RDS from SQL Central on my laptop

While trying to do so i am getting the error "Table 'FT_OBDII' has no entry in the ml_table table"

LOG FROM HCP:

W. 2016-03-28 11:46:18. <90> [10017] The consolidated and remote databases have different timestamp precisions. Consolidated database timestamps are precise to 0 digit(s) in the fractional second while the remote database timestamps are precise to 6 digit(s)

W. 2016-03-28 11:46:18. <90> [10018] Resolve the timestamp precision mismatch by setting the SQL Anywhere DEFAULT_TIMESTAMP_INCREMENT option on the remote database to 1000000 and TRUNCATE_TIMESTAMP_VALUES to 'On'. UltraLite remotes must set the TIMESTAMP_INCREMENT option to 1000000

W. 2016-03-28 11:46:18. <90> [10020] The timestamp precision mismatch may affect upload conflict detection. Use the -zp option to cause the MobiLink server to use the lowest timestamp precision for conflict detection purposes

W. 2016-03-28 11:46:18. <90> [10015] Table 'FT_OBDII' has at least one timestamp column. Due to a timestamp precision mismatch, uploaded timestamps can lose precision, defeating download filtering

E. 2016-03-28 11:46:18. <90> [-10101] Table 'FT_OBDII' has no entry in the ml_table table

ML_SCRIPTS:

call RDSUSER.ml_add_table_script( 'ABC_XYZ_V1.0', 'FT_ODBII', 'upload_insert','INSERT INTO "ABC_XYZ"."ABC_XYZ_PRJ.TABLES.FACT::FT_ODBII"("VEHICLE_IDENTIFICATION_NUMBER",

  "DATE_TIME","SOC_PERCENTAGE","ODOMETER","MOTOR_RPM_VALUE","QUICK_CHARGE_COUNT","L1_L2_CHARGE_COUNT","BATTERY_VOLTAGE", "BATTERY_STATE_OF_HEALTH",

  "BATTERY_AHR","TIRE_PRESSURE_FRONT_LEFT ","TIRE_PRESSURE_FRONT_RIGHT","TIRE_PRESSURE_REAR_LEFT ","TIRE_PRESSURE_REAR_RIGHT",

  "BATTERY_TEMP_SENSOR_1","BATTERY_TEMP_SENSOR_2","BATTERY_TEMP_SENSOR_3","BATTERY_TEMP_SENSOR_4","EVSE_CHARGER_STATUS",

  "CLIMATE_CONTROL_SETTING","ECO_DRIVER_SETTING","DRIVER_ECONOMY","KWH_REMAINING_LEAF_BATTERYPACK","DRIVING_RANGE",

  "WATTHOURS_USEDBY_LEAF_AFTER_RESET","VOLTAGE_DIFFERENCE","TEMPERATURE_DIFFERENCE","TIME_TO_FINISH_CHARGING",

  "LAST_TRIP_SOC_START_PERCENTAGE","LAST_TRIP_SOC_STOP_PERCENTAGE")

    VALUES({ml r.VEHICLE_IDENTIFICATION_NUMBER},{ml r.DATE_TIME},{ml r.SOC_PERCENTAGE},{ml r.ODOMETER}, {ml r.MOTOR_RPM_VALUE},

   {ml r.QUICK_CHARGE_COUNT},{ml r.L1_L2_CHARGE_COUNT},{ml r.BATTERY_VOLTAGE},{ml r.BATTERY_STATE_OF_HEALTH},{ml r.BATTERY_AHR},

   {ml r.TIRE_PRESSURE_FRONT_LEFT},{ml r.TIRE_PRESSURE_FRONT_RIGHT},{ml r.TIRE_PRESSURE_REAR_LEFT},{ml r.TIRE_PRESSURE_REAR_RIGHT},

   {ml r.BATTERY_TEMP_SENSOR_1},{ml r.BATTERY_TEMP_SENSOR_2},{ml r.BATTERY_TEMP_SENSOR_3},{ml r.BATTERY_TEMP_SENSOR_4},

   {ml r.EVSE_CHARGER_STATUS},{ml r.CLIMATE_CONTROL_SETTING},{ml r.ECO_DRIVER_SETTING},{ml r.DRIVER_ECONOMY},

   {ml r.KWH_REMAINING_LEAF_BATTERYPACK},{ml r.DRIVING_RANGE},{ml r.WATTHOURS_USEDBY_LEAF_AFTER_RESET}, {ml r.VOLTAGE_DIFFERENCE},

   {ml r.TEMPERATURE_DIFFERENCE},{ml r.TIME_TO_FINISH_CHARGING},{ml r.LAST_TRIP_SOC_START_PERCENTAGE},

   {ml r.LAST_TRIP_SOC_STOP_PERCENTAGE})');

call RDSUSER.ml_add_table_script( 'ABC_XYZ_V1.0', 'FT_ODBII', 'download_delete_cursor', '--{ml_ignore}');

call RDSUSER.ml_add_table_script( 'ABC_XYZ_V1.0', 'FT_ODBII', 'download_cursor','--{ml_ignore}');

call RDSUSER.ml_add_table_script( 'ABC_XYZ_V1.0', 'FT_ODBII', 'upload_update', '--{ml_ignore}');

call RDSUSER.ml_add_table_script( 'ABC_XYZ_V1.0', 'FT_ODBII', 'upload_delete', '--{ml_ignore}');

ENTRY EXISTS In ML_TABLE And So Does The Relevant Scripts(Please check screenshots below):

I have gone through some scn threads as per which the table names are case sensitive and i have verified the case for my table in HANA and in SQL Central and are both UPPER CASE

IN SQL CENTRAL:

Please help in resolving the issue.

Thanks & Regards

Madhusudan

[Former Member]

Thanks for the interest shown in helping me and please accept my apologies for replying so late. I had a milestone deliverable to make and got caught up with that.

I am not sure how to add -vRU+ to start line of the mobilink server and not aware of what 'ev' actually does.

I am already running a synchronization for other devices on field so did not experiment with this.

A help on how to use it would be much appreciated.

Is this the command you want me to execute ?

neo.bat set-application-property -h hana.ondemand.com -a ABCXYZ -b rdsabc -u S00***** --ev ML_ARGS="-zf -v"

what should i be providing after --ev ?

yes i am running the sync at high verbosity.

Thanks & Regards

Madhusudan

[Former Member]

Hi,

There is no issues with user as i am syncing other tables successfully.

Can you please elaborate on this "verbose versions of both the synchronization client output and the synchronization server log" I have just started working on Sql Anywhere and have very limited(beginners) knowledge on the tool.

I am syncing HANA on HCP from SQL Central 17 on windows Laptop.

Thanks ..

Madhusudan

[regdomaratzki]

I'm an expert on MobiLink, but a little out of the loop with respect to how MobiLink has been implemented withing the HCP environment.  I'll do my best to answer your question.

In order to change the verbosity of the MobiLink Server log, we will need to add a server option to the start line of the MobiLink Server.  In order to help debug this issue, we will add a "-vRU+" to the start line of the MobiLink Server.  There are examples on how to use the --ev switch for neo.bat at https://help.hana.ondemand.com/help/frameset.htm?ac7e5e6c84214d14a3303dfc2536f0c2.html that can add command line switches to the MobiLink Server start line.  Once you add the option, you will need to stop and start the MobiLink Server.

From a previous post, it sounds like you are connected to the remote database using Sybase Central and initiating the synchronization through Sybase Central.  I've assume that's by right-clicking on the synchronization profile you've created and selecting "Synchornize".  When you do this, set the verbosity to HIGH when you perform the synchornization, and then copy all the lines in the output window and save it to a file.  After the synchornization completes, look at MobiLink log and find the latest synchronization that took place, which almost certainly be the one you just initiaited.  A synchronization in the MobiLink log can be identified by the number in the greater-than and less-than symbols.  For example, "<90>".  All the log lines with a "<90>" after the timestamp will be associated with the same synchronization.

Reg

[regdomaratzki]

Are you sure that the remote database is synchornizing using the 'ABC_XYZ_v1.0' script version?  Earlier in the MobiLink log, there will have been a line that looked similar to :

I. 2016-03-28 11:46:18. <90> Request from "UL 17.0.0.1384 for: remote ID: bdec3ad8-20d7-3429-7893-4820d374f73e, user name: rem1, version: ABC_XYZ_v1.0

Can you confirm that the version listed in this line matches up with the script verison where you've defined the synchronization scripts that you've posted in the pictures?

Thanks,

Reg

[Former Member]

Hi,

Here is the log from SQL Central SP execution:

2016-03-28 20:35:16.672 Synchronization profile options: s=SS_obd2;e={ctp=HTTPS;adr='host=rdsabcsa57f06.hana.ondemand.com;port=443;tls_type=rsa;trusted_certificates=E:\READ\SQL_Anywhere\remote\neo.ondemand.pem';sv=ABC_XYZ_V1.0}

As can be see in the original post the SCRIPT Version is same.

I am running few other Sync Profiles with same version on the same system successfully. Not sure what exactly is the problem here..

Have tried redeploying the script also, same result

Regards

Madhusudan

[regdomaratzki]

Are you sure that the database user you are using to connect the MobiLink Server to the HANA instance is the same as the one you are using to check for the existence of the scynchronization scripts in SQL Central?

If that's not the issue, could you please post verbose versions of both the synchronization client output and the synchornization server log file when the you try and perform the synchronization?

Thanks,

Reg