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 (148 views, 10.00 KB) error-part2.jpg (139 views, 16.00 KB)
	Reply Like 0
Replies
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

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...