Bulk Insert to SQL Table failed!

Kindly try the following:-

Kindly check with the DBA if the table you are trying to write into in Access is locked or not.

If the table is not locked, try using another client to test inserting data into the same table.

Click the "Compact& Repair Database" in MS Access to fix any corruption issues.

All comments

Kindly try the following:-

Kindly check with the DBA if the table you are trying to write into in Access is locked or not.

If the table is not locked, try using another client to test inserting data into the same table.

Click the "Compact& Repair Database" in MS Access to fix any corruption issues.

Thank you @Samson Sunny for the fast reply,

Indeed the Access is locked. That could be the reason I cannot reach the table and the procedure fails.

I will try as you suggested :)

Hi @Samson Sunny,

Now I am trying to run the bulk insert to SQL table into a table in Snowflake, but I get this error:

ERROR [HY000] [DataDirect][ODBC Hybrid driver][Service]

It doesn not specify which is the issue, so I am stuck.

Do you have any suggestion on how to solve this?

Thank you :)

What are the SQL logs saying?

My guess is that this error maybe pointing to incorrect credentials. Make sure you have the source (snowflake) username and password entered correctly in the hybrid datapipeline and the pipeline's credentials entered correctly in the Board data source connection.

Thank you for the reply @Samson Sunny,

This is the log:

ERROR [HY000] [DataDirect][ODBC Hybrid driver][Service]
INSERT ALL INTO STG.TEST_BULK_INSERT (STORE_CD,TEST_BULK) VALUES (?,?)Select * from dual

I will try checking the credentials.

Thank you :)

@Samson Sunny the error is related to the layout, I want to export an entity and a cube with that entity.

I tried exporting only the cube and it works just fine.

The issue comes when I want to export the entity, but I already tried some troubleshootings:

The cube has only that entity as dimension;
The layout is set on the max detailed level;
The credentials are right;
The layout in Capsule works.

Even if I try with different entities (belonging to the same tree) it does not work…