StrataFrame Forum

BO Mapper Problem Followup

http://forum.strataframe.net/Topic1584.aspx

By Daniel Essin - 6/19/2006

Ben,

The thread in which you asked me to get ther exception details from the mapper seems to have vanished. There doesn't seem to be any way to copy the error message so that I can past it here. I've attached screen shots.
By StrataFrame Team - 6/19/2006

Not sure on the forum post disappearing... but, that's very strange that the data column "piex_trimoption" is not there...

If you open up the StrataFrame database with Enterprise Manager, does the piex_trimoption column exist on the DTEproject_item_exceptions table?  Maybe the database was somehow reverted to an older version... not sure.

By Daniel Essin - 6/19/2006

the piex_trimoption field is not there. Each time I do an install I remove SF first then have all the boxes checked about importing data and setting up the samples, etc.
By StrataFrame Team - 6/20/2006

I'm going to verify that the piex_trimoption is declared within the meta-data for the StrataFrame databases and repackage it if necessary.  I'll let you know.
By StrataFrame Team - 6/20/2006

Well, the piex_trimoption is part of the meta-data deployment package for the StrataFrame database.  There must have been an error deploying the field.  In the C:\Program Files\Common Files\MicroFour\StrataFrame\ folder, you should have some files named StrataFrame_results*.log.  These files are the log files created by the deployment process during the installation.  If you would, can you attach any and all of those log file you can to this thread so I can see if there was an error during the deployment process? 
By Daniel Essin - 6/21/2006

The forum upload would not accept the .log files so I emailed them to you.
By StrataFrame Team - 6/21/2006

Ah, yes, the relavent line within the log file is this one:

Altering table 'DTEproject_item_exceptions' failed.Alter failed for Table 'dbo.DTEproject_item_exceptions'.
An exception occurred while executing a Transact-SQL statement or batch.
Cannot alter column 'piex_customcode' because it is 'text'.

Here's the contents of my reply email:

Aha, well that tells me why you don't have the piex_trimoption field in the database... the alter table method failed because it tried to update the custom code field.

Let me take a look the problem and I'll post and update. In the meantime, you can fix your problem by altering the DTEproject_item_exceptions table by adding the piex_trimoption field. There is also another field called piex_readonly that was probably not added to your table.

piex_trimoption (int, not null) default value: ''
piex_readonly (bit, not null) default value: 0

Once you add those two fields you should be able to use the BOMapper again, and I will try to figure out why the deployment failed.
By Daniel Essin - 6/21/2006

you can't add them with "not null" because the existing records have no data.



I added them with "null allowed"
By StrataFrame Team - 6/22/2006

Yes, if you attempt to add a column with NOT NULL, you have to specify a default value so that SQL Server can populate the new column in the existing rows with the data.  In this case, you can just initialize the new rows with this:

UPDATE DTEproject_item_exceptions SET piex_trimoption = 0, piex_readonly = 0

Then, you should be in business.

By Daniel Essin - 6/23/2006

That worked