Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Output Data Tool - ORA-00901 Invalid Identifier

msbs48
7 - Meteor

 

  1. Very Simple  trying to write using Output data Tool  to Oracle Database  (tool set to Delete Data and Append).
  2. File table was created Manually using DDL Create.  Need to control the Oracle Datatypes on the table.  Alteryx set datatypes differently by default when you allow Alteryx to create its own DD, so need to use the table created by Oracle DDL
  3. Table has about 30 columns and initially when running Alterys was getting Invalid Identifier on next to last column,  Checked spelling everything was ok.  In Alteryx a disabled the offending column from being updated/inserted.. The Invalid Identifier moved up one column... I disabled ALL   columns except for the 1st  and still get Invalid Identifier on that 1st column.
  4. the table has no primary key, there was one (an identity column) and i took that out as part of the investigation.. Now the table has 30 columns, no primary key or identity column and only 1st column checked in Alteryx and still getting the Invalid Identifier.
  5. Originally work flow was writing out to Tableau data source... this still works, but in trying to get to the bottom of Output DataTool Error... i eliminated the Tableau tool as well... Now i just have the Browse Tool and the Output Data tool... The Browse Tools shows the correct rows....(1st column has data all the others are set to null)
  6. Need help out of ideas
3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus

Is everything CAPITALIZED?

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
msbs48
7 - Meteor

YOU GOT IT...

 

CAPITALIZATION IS THE KEY !!!!

 

 

MarqueeCrew
20 - Arcturus
20 - Arcturus

Better to be lucky than to be good.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels