Trust ID PBCEX logo 300x102

Duplicate column name (Oracle)

6 years 1 month ago
Mohammad Hussein
Fresh Boarder
Fresh Boarder
Posts: 1
More
Topic Author
Duplicate column name (Oracle) #5971
Hi,
I have configured the card database setup to insert new record into an oracle table after printing the student card.I have followed the help instructions for the storage items, however I'm getting the below error when printing any card::

Couldn't write data to [tname]
ORA-00957: Duplicate column name

Please help.

Thanks
6 years 4 weeks ago
Craig Bechelli
Administrator
Administrator
Posts: 624
More
Duplicate column name (Oracle) #5972
Good afternoon,

Do you have any storage items setup twice ?
Or do you also have the Primary key field setup as a storage item ?

As the Primary key is always used it is not required to be setup as a storage item, in fact this causes issues so please make sure that you do not have this setup as its own storage item.

Regards,
Craig

Craig Bechelli
CardExchange Solutions Support Team

"If you define the problem correctly, you almost have the solution." (Steve Jobs)