RevTech - Data Warehousing Bug (OpenInsight Specific)
At 30 JUN 1999 09:53:59AM Matt Sorrell wrote:
Well,
I think I've found a bug in the data warehousing routine in OpenInsight.
I was running a warehouse routine that was warehousing employee statistics. My SQL table had a 3 part key of Dept, Date, and Employee where employee is a char field. I also had my LH table for this field defined as VARCHAR.
For two departments, I had an instance where two employee numbers each were very similar; in one dept they were "7" and "007", and in the other they were "7" and "07". In a char field, these are obviously not the same values. In a number field, they would be the same.
Now, as I mentioned earlier, my datatypes in both OI and SQL where varchar and char respectively.
However, when the OI warehousing routine ran, it through an error for these two departments saying that the primary key validation failed.
I was able to work around the issue by temporarily padding the employee numbers with spaces to force a character comparison.
I am a little concerned by the appearance that OI ignores data typeing for primary key validation, however.
Perhaps I did something wrong. It wouldn't be the first time. If anyone could provide some feedback, I would appreciate it.
Matt Sorrell
msorrell@movgal.com
At 02 JUL 1999 01:42PM Cameron Revelation wrote:
Matt,
I cannot tell where the error is originating. Can you post the exact error text, so I can see if it is coming from the DataSet or even below that.
It sounds like the information is getting chopped before it even gets that far, though.
Cameron Purdy
Revelation Software
At 02 JUL 1999 05:17PM Matt Sorrell wrote:
Cameron,
I've lost my error log file. The error in the Warehouse manager was just "Error Processing Row ".
I put some debugging script that you gave me in the stored procedure and it threw an error about Primary Key validation failed.
That's all it said. I actually had to manually inspect the data.
Oh, there error was thrown on DS_APPEND_WORK$ I believe. Either that or the step right before when it is loading the dataset.
Matt Sorrell
msorrell@movgal.com
At 06 JUL 1999 07:31AM Cameron Revelation wrote:
Matt,
That sounds like the DataSet itself is rejecting the information. Is the column defined as a CHAR type in the DataSet? (You can check in the Client/Server Workspace, "Open", "DataSet", it will be WP_ and the table name.)
Cameron Purdy
Revelation Software