Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Commerce Server Setup Deployment Operations > Deploying a Pac...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 229 of 290
Post > Topic >>

Deploying a Package with Table Modifications

by Colin Bowern <colin.bowern@[EMAIL PROTECTED] > Sep 26, 2005 at 09:37 AM

I added a few columns to the ****ppingConfig table in the TransactionConfig 
database.  It seems with these modifications in place Site Packager is
unable 
to unpack this resource producing the following errors:

[11:59:38] GenericPuP: Im****tTableDataFromXMLFile: Table=****ppingConfig: 
Load XML Data file for table: ****ppingConfig: 0x5E Invalid use of Null
[11:59:38] Error im****ting object data for Transaction Config from file
C:\Do***ents 
and Settings\xxxx\Local Settings\Temp\3\Transaction Config 5:Invalid
procedure 
call or argument

The underlying ****ppingConfig.xml that is packaged in the site reflects
all 
of the proper columns but the database table was not created as such:

<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
	xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
	xmlns:rs='urn:schemas-microsoft-com:rowset'
	xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
	<s:ElementType name='row' content='eltOnly' rs:updatable='true'>
		<s:AttributeType name='****pping_method_id' rs:number='1'
rs:writeunknown='true' 
rs:basecatalog='MSCS_Store_TransactionConfig'
			 rs:basetable='****ppingConfig' rs:basecolumn='****pping_method_id'
rs:keycolumn='true'>
			<s:datatype dt:type='uuid' dt:maxLength='16' rs:fixedlength='true'
rs:maybenull='false'/>
		</s:AttributeType>
		<s:AttributeType name='****pping_method_name' rs:number='2'
rs:nullable='true' 
rs:writeunknown='true' rs:basecatalog='MSCS_Store_TransactionConfig'
			 rs:basetable='****ppingConfig' rs:basecolumn='****pping_method_name'>
			<s:datatype dt:type='string' dt:maxLength='255'/>
		</s:AttributeType>
		<s:AttributeType name='description' rs:number='3' rs:nullable='true'
rs:writeunknown='true' 
rs:basecatalog='MSCS_Store_TransactionConfig'
			 rs:basetable='****ppingConfig' rs:basecolumn='description'>
			<s:datatype dt:type='string' dt:maxLength='255'/>
		</s:AttributeType>
		<s:AttributeType name='action_page' rs:number='4' rs:nullable='true'
rs:writeunknown='true' 
rs:basecatalog='MSCS_Store_TransactionConfig'
			 rs:basetable='****ppingConfig' rs:basecolumn='action_page'>
			<s:datatype dt:type='string' dt:maxLength='255'/>
		</s:AttributeType>
		<s:AttributeType name='action_friendly_name' rs:number='5'
rs:nullable='true' 
rs:writeunknown='true' rs:basecatalog='MSCS_Store_TransactionConfig'
			 rs:basetable='****ppingConfig' rs:basecolumn='action_friendly_name'>
			<s:datatype dt:type='string' dt:maxLength='255'/>
		</s:AttributeType>
		<s:AttributeType name='progid' rs:number='6' rs:nullable='true'
rs:writeunknown='true' 
rs:basecatalog='MSCS_Store_TransactionConfig'
			 rs:basetable='****ppingConfig' rs:basecolumn='progid'>
			<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='255'/>
		</s:AttributeType>
		<s:AttributeType name='config' rs:number='7' rs:nullable='true'
rs:writeunknown='true' 
rs:basecatalog='MSCS_Store_TransactionConfig'
			 rs:basetable='****ppingConfig' rs:basecolumn='config'>
			<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='2147483647' 
rs:long='true'/>
		</s:AttributeType>
		<s:AttributeType name='enabled' rs:number='8' rs:nullable='true'
rs:writeunknown='true' 
rs:basecatalog='MSCS_Store_TransactionConfig'
			 rs:basetable='****ppingConfig' rs:basecolumn='enabled'>
			<s:datatype dt:type='int' dt:maxLength='4' rs:precision='10'
rs:fixedlength='true'/>
		</s:AttributeType>
		<s:AttributeType name='language_id' rs:number='9' rs:nullable='true'
rs:writeunknown='true' 
rs:basecatalog='MSCS_Store_TransactionConfig'
			 rs:basetable='****ppingConfig' rs:basecolumn='language_id'>
			<s:datatype dt:type='string' dt:maxLength='128'/>
		</s:AttributeType>
		<s:AttributeType name='****pping_method_type' rs:number='10'
rs:nullable='true' 
rs:writeunknown='true' rs:basecatalog='MSCS_Store_TransactionConfig'
			 rs:basetable='****ppingConfig' rs:basecolumn='****pping_method_type'>
			<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='20'/>
		</s:AttributeType>
		<s:AttributeType name='visible' rs:number='11' rs:nullable='true'
rs:writeunknown='true' 
rs:basecatalog='MSCS_Store_TransactionConfig'
			 rs:basetable='****ppingConfig' rs:basecolumn='visible'>
			<s:datatype dt:type='boolean' dt:maxLength='2' rs:fixedlength='true'/>
		</s:AttributeType>
		<s:AttributeType name='display_rank' rs:number='12' rs:nullable='true' 
rs:writeunknown='true' rs:basecatalog='MSCS_Store_TransactionConfig'
			 rs:basetable='****ppingConfig' rs:basecolumn='display_rank'>
			<s:datatype dt:type='int' dt:maxLength='4' rs:precision='10'
rs:fixedlength='true'/>
		</s:AttributeType>
		<s:AttributeType name='countries_sup****ted' rs:number='13'
rs:nullable='true' 
rs:writeunknown='true' rs:basecatalog='MSCS_Store_TransactionConfig'
			 rs:basetable='****ppingConfig' rs:basecolumn='countries_sup****ted'>
			<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='255'/>
		</s:AttributeType>
		<s:extends type='rs:rowbase'/>
	</s:ElementType>
</s:Schema>
<rs:data>
	<z:row ****pping_method_id='{00000000-0000-0000-0000-002468008034}'
****pping_method_name='Quick' 
description='(7 to 10 business days)'
		 action_page='ChargeByQuantity_edit.asp' action_friendly_name='Charge by

Quantity' progid='commerce.stepwise****pping'
		 config='&#x3c;DICTIONARY
xmlns:dt=&#x22;uuid:304FB305-29A4-11d3-B0D4-00C04F8ED7A2&#x22; 
version=&#x22;1.0&#x22;&#x3e;
&#x3c;DICTITEM key=&#x22;mode&#x22;&#x3e;&#x3c;VALUE
dt:dt=&#x22;i2&#x22;&#x3e;1&#x3c;/VALUE&#x3e;&#x3c;/DICTITEM&#x3e;
&#x3c;/DICTIONARY&#x3e;
' enabled='1' language_id='en-US' ****pping_method_type='****p'
visible='True' 
display_rank='1' countries_sup****ted=''/>
</rs:data>
</xml>

Is there a recommended way of packaging a site with table modifications to

out-of-the-box tables?

Thanks,
Colin
 




 5 Posts in Topic:
Deploying a Package with Table Modifications
Colin Bowern <colin.bo  2005-09-26 09:37:55 
RE: Deploying a Package with Table Modifications
=?Utf-8?B?UmF2aSBTaGFua2F  2005-09-26 10:31:06 
RE: Deploying a Package with Table Modifications
Colin Bowern <colin.bo  2005-09-26 11:10:57 
RE: Deploying a Package with Table Modifications
Colin Bowern <colin.bo  2005-09-26 13:22:53 
RE: Deploying a Package with Table Modifications
vtadas@[EMAIL PROTECTED]   2005-09-27 06:52:07 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 12:49:30 CST 2008.