Skip to main content
Question

Azure Writer keeps giving me an create table error when I'm trying to insert

  • February 14, 2020
  • 1 reply
  • 46 views
N

Hello Everyone,

I am trying to write some structured data into an existing table into AZURE. The table is already created but there is no data in the tables. I have set up the connections and have the correct table name so no issue there. Also, the fields I am trying to write match the naming conventions of the AZURE table.

As you can see from the screen shot below I have chose insert but I am receiving this error message ( below screenshot)

 

 

0.0|ERROR |Microsoft Azure SQL Database Non-Spatial Writer: Failed to create Azure table 'siro_stg.MAD' because no clustered index or primary key was specified. If creating a new table, go into the 'User Attribute' tab and set the 'Index' column to 'clustered', 'clustered_not_null', or 'primary_key' for a column

The AZURE DB table has no primary key set or indexing. I was told this shouldn't matter as we are treating this as a staging area table.

Not sure why this error is appearing as I'm not trying to create a table just insert into a pre existing one. I have also tried update and selecting all matched rows but the same error is appearing.

Any Ideas what I'm missing for this workspace to run successfully?

 

I can supply the work space if needed for further clarity.

 

Thanks!

1 reply

nampreetatsafe
Safer
Forum|alt.badge.img+12

Hi @neil1989! A couple things you can try:

1) Try placing siro_stg in the Table Qualifier parameter:

 

2) If the destination table is already created, have you tried adding the Writer feature type by Importing from Dataset and pointing to the siro_stg.MAD table on AZURE? If you've already created the Writer connecting to your Azure instance, you can do this by going to Writers > Import Feature Type, or if you want to do it from scratch, when adding the Writer, under Table Definition, select Importing from Dataset...:

Hope this helps!

Reply


Helpful Members This Week

Community Stats

30,985
Posts
117,433
Replies
38,764
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.