AXForum  
Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
CRM
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 03.12.2012, 23:11   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
emeadaxsupport: P job Error 32769 in Retail Store Connect
Источник: http://blogs.msdn.com/b/axsupport/ar...e-connect.aspx
==============

When fetching data from the StoreDB you might see this message. The reason is normally configuration keys or added system fields. By adding the code suggestion, the system will report all the columns that are incorrect and you can then take action by mofifying the Transfer field list in AX subjobs.



ERROR IN THE HQ RETAIL STORE CONNECT

ERROR 32769

Target request handler failed to process target request header: SCAXRequestHandlerException: AX target request handler failed to process request: AX Managed Interop failure. ErrorException: Error when bulk inserting data. Target table: RetailTran







CODE SUGGESTION

\Classes\RetailConnSCDataBulkCopy\bulkCopyToTemp

public void bulkCopyToTemp(str physicalTempDBTableName)

{


System.Data.SqlClient.SqlBulkCopy sqlBulkCopy;


str connStr;


System.Data.SqlClient.SqlBulkCopyColumnMappingCollection colMapping;


str columnName;


str dstTableName;


int i;


System.Xml.XmlReader xmlReader;


Microsoft.Dynamics.Retail.StoreConnect.Request.Base.SCSimpleXmlDataReader
xmlDataReader;




System.Collections.Specialized.StringCollection columnNameCollection;


System.Collections.Specialized.StringCollection guidColumnNameCollection;




System.Exception clrException;


str exceptionMessage;


str columnName2;


str missingColumns;


str systemfields1 = 'CreatedBy';


str systemfields2 = 'ModifiedBy';


str systemfields3 = 'ModifiedDateTime';


str systemfields4 = 'CreatedDateTime';


str systemfields5 = 'CreatedTransactionId';


str systemfields6 = 'ModifiedTransactionid';


str systemfields7 = 'Recid';


str systemfields8 = 'RecVersion';


;


columnNameCollection = new
System.Collections.Specialized.StringCollection();


guidColumnNameCollection = new
System.Collections.Specialized.StringCollection();




for (i = 1; i Microsoft.Dynamics.AX.ManagedInterop.ErrorException:

Error when bulk inserting data.

Target table: RetailTransactionTable

Target columns: createdBy,modifiedby,



Check if these fields are disabled by the
license configuration keys.

If the configuration keys are correct,
change the transfer fieldlist on the scheduler subjob.

It is also not allowed to add system
fields to the Transferfield list 'CreatedBy,ModifiedBy, ModifiedDateTime,
CreatedDateTime, CreatedTransactionId, ModifiedTransactionid, Recid, RecVersion'




System.Reflection.TargetInvocationException:
Exception has been thrown by the target of an invocation. --->
System.InvalidOperationException: The given ColumnMapping does not match up
with any column in the source or destination.

at
System.Data.SqlClient.SqlBulkCopy.AnalyzeTargetAndCreateUpdateBulkCommand(BulkCopySimpleResultSet
internalResults)

at
System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()

at
System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)

at
System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader)

--- End of inner exception
stack trace ---

at
System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object
target, Object[] arguments, SignatureStruct& sig, MethodAttributes
methodAttributes, RuntimeType typeOwner)

at
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr,
Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)

at
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr,
Binder binder, Object[] parameters, CultureInfo culture)

at
Microsoft.Dynamics.AX.ManagedInterop.ClrBridgeImpl.InvokeClrInstanceMethod(ClrBridgeImpl*
, ObjectWrapper* objectWrapper, Char* pszMethodName, Int32 argsLength,
ObjectWrapper** arguments, Boolean* argsAreByRef, Boolean* isException)

t100543_890F916D362F4C1C8368EE4FEECE4AF2.1

at
Microsoft.Dynamics.AX.ManagedInterop.Object.CallWithReturnType(String
methodName, Type returnType, Object[] paramList)

at
Microsoft.Dynamics.AX.ManagedInterop.Object.Call(String methodName)

at
Microsoft.Dynamics.Retail.StoreConnect.Request.AXHandler.SCAXTargetRequestHandler.ProcessTargetRequestHeader(ISCTargetRequestHeader
targetRequestHeader)

--- End of inner exception
stack trace ---

at
Microsoft.Dynamics.Retail.StoreConnect.Request.AXHandler.SCAXTargetRequestHandler.ProcessTargetRequestHeader(ISCTargetRequestHeader
targetRequestHeader)

at
CCommMgr.ProcessTargetRequest(CCommMgr* ,
basic_string* r_file_path, SCRequestHandlerManager scRequestHandlerManager)







Author: Kim Truelsen

Release date: 3/12-2012






Источник: http://blogs.msdn.com/b/axsupport/ar...e-connect.aspx
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
emeadaxsupport: AX2012 Retail error 32769 in Store connect while running P-job Blog bot DAX Blogs 0 10.06.2012 14:12
emeadaxsupport: AX for Retail: Bulk insert error in Store connect when running P job (error 32769) Blog bot DAX Blogs 0 01.06.2012 13:11
axinthefield: Dynamics Ax 2009 Retail Error Messages & Possible resolutions Blog bot DAX Blogs 0 23.05.2012 11:11
emeadaxsupport: AX for Retail 2012: Store Connect missing mfc100u.dll error Blog bot DAX Blogs 0 25.04.2012 03:18
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 00:19.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.