[U2] I Descriptor no longer working in UniSQL after UD upgrade
Hi we upgraded from UD 5.2/Solaris to UD 7.2/RH about a month ago and so it looked fine so far. Now I had a call that there are purchase orders missing on a Cognos report. When I investigated I noticed that from the day of the upgrade I have rows in the table used for that report with missing dates. The report is based on a SQL Server 2000 table that gets updated every night with Purchasing information from UD using DTS. We want to track supplier performance so I take a snapshot of the outstanding Purchase order deliveries every night and add them to this table. Each row also contains the date the snapshot was done. Some order line have multiple deliveries so I created a I-type dictionary item using REUSE(@DATE). This is mapped in the schema and was working just fine under 5.2 but now there is only a date for the first multivalue. I created a new subtable using the 7.2 VSG and the result is the same. The dictionary works just fine from ECL but in SQL only the first row has a date and all others are null. Any idea why this doesn't work anymore under UD 7.2? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Descriptor no longer working in UniSQL after UD upgrade
Could it be that the dates are coming through in the wrong format? e.g. if you need to change the DEFAULTS definition in your ENGLISH.MSG file? Just a thought Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 05 March 2013 12:42 To: U2 Users List Subject: [U2] I Descriptor no longer working in UniSQL after UD upgrade Hi we upgraded from UD 5.2/Solaris to UD 7.2/RH about a month ago and so it looked fine so far. Now I had a call that there are purchase orders missing on a Cognos report. When I investigated I noticed that from the day of the upgrade I have rows in the table used for that report with missing dates. The report is based on a SQL Server 2000 table that gets updated every night with Purchasing information from UD using DTS. We want to track supplier performance so I take a snapshot of the outstanding Purchase order deliveries every night and add them to this table. Each row also contains the date the snapshot was done. Some order line have multiple deliveries so I created a I-type dictionary item using REUSE(@DATE). This is mapped in the schema and was working just fine under 5.2 but now there is only a date for the first multivalue. I created a new subtable using the 7.2 VSG and the result is the same. The dictionary works just fine from ECL but in SQL only the first row has a date and all others are null. Any idea why this doesn't work anymore under UD 7.2? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Descriptor no longer working in UniSQL after UD upgrade
Sorry, that can't be the case. Should have read more carefully :( -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: 05 March 2013 13:12 To: 'U2 Users List' Subject: Re: [U2] I Descriptor no longer working in UniSQL after UD upgrade Could it be that the dates are coming through in the wrong format? e.g. if you need to change the DEFAULTS definition in your ENGLISH.MSG file? Just a thought Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 05 March 2013 12:42 To: U2 Users List Subject: [U2] I Descriptor no longer working in UniSQL after UD upgrade Hi we upgraded from UD 5.2/Solaris to UD 7.2/RH about a month ago and so it looked fine so far. Now I had a call that there are purchase orders missing on a Cognos report. When I investigated I noticed that from the day of the upgrade I have rows in the table used for that report with missing dates. The report is based on a SQL Server 2000 table that gets updated every night with Purchasing information from UD using DTS. We want to track supplier performance so I take a snapshot of the outstanding Purchase order deliveries every night and add them to this table. Each row also contains the date the snapshot was done. Some order line have multiple deliveries so I created a I-type dictionary item using REUSE(@DATE). This is mapped in the schema and was working just fine under 5.2 but now there is only a date for the first multivalue. I created a new subtable using the 7.2 VSG and the result is the same. The dictionary works just fine from ECL but in SQL only the first row has a date and all others are null. Any idea why this doesn't work anymore under UD 7.2? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Descriptor no longer working in UniSQL after UD upgrade
Have your compiled your i-descriptor? Is it marked as MV? David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Tuesday, March 05, 2013 5:42 AM To: U2 Users List Subject: [U2] I Descriptor no longer working in UniSQL after UD upgrade Hi we upgraded from UD 5.2/Solaris to UD 7.2/RH about a month ago and so it looked fine so far. Now I had a call that there are purchase orders missing on a Cognos report. When I investigated I noticed that from the day of the upgrade I have rows in the table used for that report with missing dates. The report is based on a SQL Server 2000 table that gets updated every night with Purchasing information from UD using DTS. We want to track supplier performance so I take a snapshot of the outstanding Purchase order deliveries every night and add them to this table. Each row also contains the date the snapshot was done. Some order line have multiple deliveries so I created a I-type dictionary item using REUSE(@DATE). This is mapped in the schema and was working just fine under 5.2 but now there is only a date for the first multivalue. I created a new subtable using the 7.2 VSG and the result is the same. The dictionary works just fine from ECL but in SQL only the first row has a date and all others are null. Any idea why this doesn't work anymore under UD 7.2? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
