-
Ok, i checked that. vert is null in some cases. That does not change that it works in milestone2 (and older).
May it help to adjust the transformation of vert to something like:
IF(isnull(vert),'',vert)
Or does this not change the key handling?.
2009-08-03 10:50:49 UTC in Jitterbit - Open Source Integration
-
One thing came to my mind. Maybe the value for "vert" is a NULL-Value in the source table. And from my experiences the old version of jitterbit was less rigorous with NULLs.
I can check this on monday.
2009-08-01 16:53:05 UTC in Jitterbit - Open Source Integration
-
No. it still works with the old version, but with the same values. I am back on milestone2 and everything is fine again.
But if you say it should not work, then its ok, and i will stay with this version.
2009-07-31 18:03:06 UTC in Jitterbit - Open Source Integration
-
Ups, seems like my fault. Forgot the where clause to filter the rows with empty lastsemhs.
2009-07-30 13:11:15 UTC in Jitterbit - Open Source Integration
-
Finally found the "add a file" button :)
2009-07-30 12:38:33 UTC in Jitterbit - Open Source Integration
-
I will now go to milestone2 again, as i need to get it working, and that version works for me.
Hope the information down there helps.
2009-07-30 11:19:37 UTC in Jitterbit - Open Source Integration
-
some more log:
13:03:06: User Log Setting: Can Create Log file
13:03:06: Created the partial log file 'C:\Programme\Jitterbit Integration Server\DataInterchange/Temp/LOG/3_d9357681-c609-46b4-a1a3-13cbd8a747f9.txt'
13:03:06: stOutputDataFileName = C:/WINDOWS/Temp/jitterbit/OpId_3_853e06ea-b5cc-4651-8f72-c29f20cb06d5/5bebeadb-7145-4b89-a98e-86b09378eccb_target
13:03:06:
--------------------...
2009-07-30 11:18:19 UTC in Jitterbit - Open Source Integration
-
tgtOdbc:
Insert SQL = 'INSERT INTO `sosstg` (`mtknr`,`abschl`,`stg`,`vert`,`semester`,`status`,`stgsem`,`endegrd`,`pversion`) VALUES (100999,'BO','CB','',20062,'R',2,'','2004')'
Update SQL = ''
Insert/Update SQL = 'INSERT INTO `sosstg` (`mtknr`,`abschl`,`stg`,`vert`,`semester`,`status`,`stgsem`,`endegrd`,`pversion`) VALUES (100999,'BO','CB','',20062,'R',2,'','2004')'.
2009-07-30 11:16:55 UTC in Jitterbit - Open Source Integration
-
LOG:
13:03:05: User Log Setting: Can Create Log file
13:03:05: Created the partial log file 'C:\Programme\Jitterbit Integration Server\DataInterchange/Temp/LOG/3_d9357681-c609-46b4-a1a3-13cbd8a747f9.txt'
13:03:05:
-------------------- 7/30/2009 13:3:5 -------------------------
13:03:05: 1> TreeMapper::MapByOperationID - Begin
13:03:05: bstrDSN = UID=jitterbit;PWD=
2009-07-30 11:16:07 UTC in Jitterbit - Open Source Integration
-
Transformation:
2009-07-30 11:15:20 UTC in Jitterbit - Open Source Integration
