BO Mapper Problem Followup

StrataFrame Forum

Back

BO Mapper Problem Followup

Author	Message
Daniel Essin	Daniel Essin posted 19 Years Ago Topic Details Share Topic
Group: Forum Members Posts: 235, Visits: 309	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. Attachments error-part1.jpg (139 views, 10.00 KB) error-part2.jpg (126 views, 16.00 KB)
	Reply Like 0
StrataFrame Team	S StrataFrame Team posted 19 Years Ago Post Details Share Post
S Group: StrataFrame Developers Posts: 3K, Visits: 2.5K	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.
	Reply Like 0
Daniel Essin	Daniel Essin posted 19 Years Ago Post Details Share Post
Group: Forum Members Posts: 235, Visits: 309	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.
	Reply Like 0
StrataFrame Team	S StrataFrame Team posted 19 Years Ago Post Details Share Post
S Group: StrataFrame Developers Posts: 3K, Visits: 2.5K	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.
	Reply Like 0
StrataFrame Team	S StrataFrame Team posted 19 Years Ago Post Details Share Post
S Group: StrataFrame Developers Posts: 3K, Visits: 2.5K	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?
	Reply Like 0
Daniel Essin	Daniel Essin posted 19 Years Ago Post Details Share Post
Group: Forum Members Posts: 235, Visits: 309	The forum upload would not accept the .log files so I emailed them to you.
	Reply Like 0
StrataFrame Team	S StrataFrame Team posted 19 Years Ago Post Details Share Post
S Group: StrataFrame Developers Posts: 3K, Visits: 2.5K	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.
	Reply Like 0
Daniel Essin	Daniel Essin posted 19 Years Ago Post Details Share Post
Group: Forum Members Posts: 235, Visits: 309	you can't add them with "not null" because the existing records have no data. I added them with "null allowed"
	Reply Like 0
StrataFrame Team	S StrataFrame Team posted 19 Years Ago Post Details Share Post
S Group: StrataFrame Developers Posts: 3K, Visits: 2.5K	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.
	Reply Like 0
Daniel Essin	Daniel Essin posted 19 Years Ago Post Details Share Post
Group: Forum Members Posts: 235, Visits: 309	That worked
	Reply Like 0