Good Morning everyone,
I am facing a problem again with a webmethods JDBC adapter.
I am trying to extract values from a csv file, which i want to read using a polling port and save those values to my database.
I have created a test service where i enter the transport info, which usually comes from the polling port, manually and then call the services which is called by my polling port as well.
For my test service i save the file with the FilePolling Prefix in the work folder. This service is able to grab the file and extract the values and save them to the database.
When I save the file in the inbound folder of my Polling Port i can see, that the server gets the file and transfers it to the work folder and afterwards to the done folder. But for some reason i always get the following error message when the service is trying to write the extracted information to the database:
Cannot insert the value NULL into column ‘EFFECTIVE_DATE’, table ‘NETZ_PDV.dbo.INP_WM_PDV_DV_PMES_IMPORT_PANDA’; column does not allow nulls. INSERT fails.
259 Cannot insert the value NULL into column ‘EFFECTIVE_DATE’, table ‘NETZ_PDV.dbo.INP_WM_PDV_DV_PMES_IMPORT_PANDA’; column does not allow nulls. INSERT fails."
[ADA.1.316] Cannot execute the SQL statement “insert into INP_WM_PDV_DV_PMES_IMPORT_PANDA (EFFECTIVE_DATE, DELIVERY_BASE, DISTRICT, PANDA_CREATION_TIME, PZ, ZB, ZBEZ, FILENAME) values (?,?,?,?,?,?,?,?)”. "
2015-10-28 07:30:30 CET [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service dp.de.fulfillment.import_Panda.v1_0.load.adapterInternal.table_INP_WM_PDV_DV_PMES_IMPORT_PANDA:insert_ZustellnetzDatei.
It is the same file so i know, that the values, which are supposed to be written in the database are not null.
I hope someone can help me and that this is enough details
Thanks in advance