Hello,
I'm trying to synchronize the database and I'm getting these 2 errors:
Error Sincronizar base de datos No se puede ejecutar la operación de base de datos requerida.
La base de datos SQL ha emitido un error.
Información Sincronizar base de datos Descripción de error SQL: [Microsoft][SQL Server Native Client 11.0][SQL Server]Error converting data type nvarchar to numeric.
Información Sincronizar base de datos Instrucción SQL: INSERT INTO X100479X SELECT ABCCONTRIBUTIONMARGIN,ABCREVENUE,ABCTIEUP,ABCVALUE,ALTCONFIGID,ALTINVENTCOLORID,ALTINVENTSIZEID,ALTINVENTSTYLEID,ALTITEMID,ASSETGROUPID_RU,ASSETID_RU,AUTOREPORTFINISHED,AXMDMCODE,BARCODESETUPID,BASECOMPARISONUNITCODE,BATCHNUMGROUPID,BLOCKEDONPOS,BOMCALCGROUPID,BOMLEVEL,BOMMANUALRECEIPT,BOMUNITID,COMMISSIONGROUPID,COSTGROUPID,COSTMODEL,CUSTOMSTARIFFCODETABLE_IN_DIR_EXP,CUSTOMSTARIFFCODETABLE_IN_DIR_IMP,CUSTOMSTARIFFCODETABLE_IN_TARIFFCODE_EXP,CUSTOMSTARIFFCODETABLE_IN_TARIFFCODE_IMP,CUSTVENDEXTERNALITEM_ABCCATEGORY,CUSTVENDEXTERNALITEM_CUSTVENDRELATION,CUSTVENDEXTERNALITEM_DESCRIPTION,CUSTVENDEXTERNALITEM_EXTERNALITEMID,CUSTVENDEXTERNALITEM_EXTERNALITEMTXT,CUSTVENDEXTERNALITEM_MODULETYPE,DATEBLOCKED,DATETOACTIVATEITEM,DATETOBEBLOCKED,DEFAULTDIMENSION,DEFAULTORDERTYPE,DEFINITIONGROUP,DENSITY,DEPTH,DISPLAYPRODUCTNUMBER,ECORESPRODUCTDIMENSIONGROUP_NAME,ECORESPRODUCTTRANSLATION_DESCRIPTION,ECORESPRODUCTTRANSLATION_LANGUAGEID,ECORESPRODUCTTRANSLATION_NAME,ECORESSTORAGEDIMENSIONGROUP_NAME,ECORESTRACKINGDIMENSIONGROUP_NAME,EPCMANAGER,EXCEPTIONCODE_BR,EXCISETARIFFCODES_IN_TARIFFCODE,EXECUTIONID,EXIMPRODUCTGROUPTABLE_IN_PRODUCTGROUP,FISCALLIFOAVOIDCALC,FISCALLIFONORMALVALUE,FISCALLIFONORMALVALUECALC,FITAXATIONORIGIN_BR,FORECASTDMPINCLUDE,GROSSDEPTH,GROSSHEIGHT,GROSSWIDTH,GROUPID,HEIGHT,ICMSONSERVICE_BR,INTRACODE,INTRASTATPROCID_CZ,INTRAUNIT,INVENTDIM_CONFIGID,INVENTDIM_INVENTSIZEID,INVENTPRODUCTTYPE_BR,INVENTSITEID,INVENTTABLEMODULEINVENT_ALLOCATEMARKUP,INVENTTABLEMODULEINVENT_ENDDISC,INVENTTABLEMODULEINVENT_LINEDISC,INVENTTABLEMODULEINVENT_MARKUPSECCUR_RU,INVENTTABLEMODULEINVENT_MAXIRETPRICE_IN,INVENTTABLEMODULEINVENT_MAXPRICEINCLVAT,INVENTTABLEMODULEINVENT_MINPRICEINCLVAT,INVENTTABLEMODULEINVENT_MULTILINEDISC,INVENTTABLEMODULEINVENT_OVERDELIVERYPCT,INVENTTABLEMODULEINVENT_PDSPRICPRECISION,INVENTTABLEMODULEINVENT_PRICE,INVENTTABLEMODULEINVENT_PRICEDATE,INVENTTABLEMODULEINVENT_PRICEINCLVAT,INVENTTABLEMODULEINVENT_PRICEQTY,INVENTTABLEMODULEINVENT_PRICESECCUR_RU,INVENTTABLEMODULEINVENT_PRICEUNIT,INVENTTABLEMODULEINVENT_SUPPITEMGROUPID,INVENTTABLEMODULEINVENT_TAXITEMGROUPID,INVENTTABLEMODULEINVENT_UNDERDELIVERYPCT,INVENTTABLEMODULEINVENT_UNITID,INVENTTABLEMODULEINVENTPURCH_ENDDISC,INVENTTABLEMODULEINVENTSALES_ENDDISC,INVENTTABLEMODULEPURCH_ALLOCATEMA,INVENTTABLEMODULEPURCH_ENDDISC,INVENTTABLEMODULEPURCH_LINEDISC,INVENTTABLEMODULEPURCH_MARKUPSECCUR_RU,INVENTTABLEMODULEPURCH_MAXIRETPRICE_IN,INVENTTABLEMODULEPURCH_MAXPRICEINCLVAT,INVENTTABLEMODULEPURCH_MINPRICEINCLVAT,INVENTTABLEMODULEPURCH_MULTILINEDISC,INVENTTABLEMODULEPURCH_OVERDELIVERYPCT,INVENTTABLEMODULEPURCH_PDSPRICPRECISION,INVENTTABLEMODULEPURCH_PRICE,INVENTTABLEMODULEPURCH_PRICEDATE,INVENTTABLEMODULEPURCH_PRICEINCLVAT,INVENTTABLEMODULEPURCH_PRICEQTY,INVENTTABLEMODULEPURCH_PRICESECCUR_RU,INVENTTABLEMODULEPURCH_PRICEUNIT,INVENTTABLEMODULEPURCH_SUPPITEMGR,INVENTTABLEMODULEPURCH_TAXITEMGROUPID,INVENTTABLEMODULEPURCH_UNDERDELIVERYPCT,INVENTTABLEMODULEPURCH_UNITID,INVENTTABLEMODULESALES_ALLOCATEMA,INVENTTABLEMODULESALES_ENDDISC,INVENTTABLEMODULESALES_LINEDISC,INVENTTABLEMODULESALES_MARKUPSECCUR_RU,INVENTTABLEMODULESALES_MAXIRETPRICE_IN,INVENTTABLEMODULESALES_MAXPRICEINCLVAT,INVENTTABLEMODULESALES_MINPRICEINCLVAT,INVENTTABLEMODULESALES_MULTILINEDISC,INVENTTABLEMODULESALES_OVERDELIVERYPCT,INVENTTABLEMODULESALES_PDSPRICPRECISION,INVENTTABLEMODULESALES_PRICE,INVENTTABLEMODULESALES_PRICEDATE,INVENTTABLEMODULESALES_PRICEINCLVAT,INVENTTABLEMODULESALES_PRICEQTY,INVENTTABLEMODULESALES_PRICESECCUR_RU,INVENTTABLEMODULESALES_PRICEUNIT,INVENTTABLEMODULESALES_SUPPITEMGR,INVENTTABLEMODULESALES_TAXITEMGROUPID,INVENTTABLEMODULESALES_UNDERDELIVERYPCT,INVENTTABLEMODULESALES_UNITID,ISSELECTED,ITEMBUYERGROUPID,ITEMDIMCOSTPRICE,ITEMGROUPID,ITEMID,ITEMINVENTLOCATIONID,ITEMPRICETOLERANCEGROUPID,ITEMTAGGINGLEVEL,ITEMTYPE,KEYINGINPRICE,KEYINGINQTY,LIFEFROM,LIFETO,LOWESTQTY,MARKUPCODE_RU,MATCHINGPOLICY,MINIMUMPALLETQUANTITY,MODELGROUPID,MUSTKEYINCOMMENT,NAMEALIAS,NETWEIGHT,NODISCOUNTALLOWED,NRTAXGROUP_LV,ORIGCOUNTRYREGIONID,ORIGCOUNTYID,ORIGSTATEID,PACKAGINGGROUPID,PACKING_RU,PALLETTAGGING,PBAAUTOSTART,PBAHIDEAPPROVAL,PBAHIDEDIALOG,PBAINVENTITEMGROUPID,PBAITEMAUTOGENERATED,PBAITEMCONFIGURABLE,PBAMANDATORYCONFIG,PDSBASEATTRIBUTEID,PDSBESTBEFORE,PDSCWPRODUCT,PDSCWWMSMINIMUMPALLETQTY,PDSCWWMSQTYPERLAYER,PDSCWWMSSTANDARDPALLETQTY,PDSFREIGHTALLOCATIONGROUPID,PDSITEMREBATEGROUPID,PDSPOTENCYATTRIBRECORDING,PDSSHELFADVICE,PDSSHELFLIFE,PDSTARGETFACTOR,PDSVENDORCHECKITEM,PHANTOM,PKWIUCODE_PL,PMFPLANNINGITEMID,PMFPRODUCTTYPE,PMFYIELDPCT,PRIMARYVENDORID,PRODFLUSHINGPRINCIP,PRODGROUPID,PRODPOOLID,PRODUCTSUBTYPE,PRODUCTTYPE,PROJCATEGORYID,PROPERTYID,PURCHINVENTLOCATIONID,PURCHMODEL,QTYBECOMESNEGATIVE,QTYPERLAYER,RELEASEPRODUCTCOMPANY,REQGROUPID,SADRATECODE_PL,SALESCONTRIBUTIONRATIO,SALESINVENTLOCATIONID,SALESMODEL,SALESPERCENTMARKUP,SALESPRICEMODELBASIC,SCALEITEM,SCRAPCONST,SCRAPVAR,SEARCHNAME,SEASONCODE,SERIALNUMGROUPID,SERVICECODETABLE_IN_SERVICECODE,SKIPINTRACOMPANYSYNC_RU,SORTCODE,STANDARDCONFIGID,STANDARDINVENTCOLORID,STANDARDINVENTSIZEID,STANDARDPALLETQUANTITY,STATISTICSFACTOR,TARAWEIGHT,TAXFISCALCLASSIFICATION_BR,TAXPACKAGINGQTY,TAXSERVICECODE_BR,TRANSFERSTATUS,UNITVOLUME,USEALTITEMID,USEEANSTANDARDBARCODE,VARIANTCONFIGURATIONTECHNOLOGY,WIDTH,WMSARRIVALHANDLINGTIME,WMSPALLETTYPEID,WMSPICKINGQTYTIME,ZEROPRICEVALID,{fn SUBSTRING(BATCHMERGEDATECALCULATIONMETHOD,1,6)},COUNTGROUPID,'','','',FILTERCHANGED,'',FILTERCODE,{fn SUBSTRING(FILTERGROUP,1,10)},{fn CONVERT(HARMONIZEDCODE,SQL_NUMERIC)},{fn SUBSTRING({fn CONVERT(INVENTITEMINV_ATPBACKWARDDEMANDTIMEFENCE,SQL_VARCHAR)},1,20)},{fn SUBSTRING({fn CONVERT(INVENTITEMINV_ATPBACKWARDSUPPLYTIMEFENCE,SQL_VARCHAR)},1,20)},{fn SUBSTRING({fn CONVERT(INVENTITEMINVENT_ATPAPPLYDEMANDTIMEFENCE,SQL_VARCHAR)},1,20)},{fn SUBSTRING({fn CONVERT(INVENTITEMINVENT_ATPAPPLYSUPPLYTIMEFENCE,SQL_VARCHAR)},1,20)},INVENTITEMINVENT_ATPINCLPLANNEDORDERS,{fn CONVERT(INVENTITEMINVENT_DELIVERYDATECONTROLTYPE,SQL_NUMERIC)},INVENTITEMINVENT_MANDATORYINVENTLOCATION,INVENTITEMINVENTSETU_MANDATORYINVENTSITE,{fn SUBSTRING({fn CONVERT(INVENTITEMINVENTSETUP_ATPTIMEFENCE,SQL_VARCHAR)},1,7)},{fn SUBSTRING({fn CONVERT(INVENTITEMINVENTSETUP_HIGHESTQTY,SQL_VARCHAR)},1,20)},INVENTITEMINVENTSETUP_INVENTSITEDEFAULT,{fn SUBSTRING({fn CONVERT(INVENTITEMINVENTSETUP_LEADTIME,SQL_VARCHAR)},1,10)},INVENTITEMINVENTSETUP_LOWESTQTY,INVENTITEMINVENTSETUP_MULTIPLEQTY,INVENTITEMINVENTSETUP_OVERRIDE,INVENTITEMINVENTSETUP_STANDARDQTY,INVENTITEMINVENTSETUP_STOPPED,INVENTITEMPURCH_MANDATORYINVENTLOCATION,INVENTITEMPURCHSETUP_HIGHESTQTY,INVENTITEMPURCHSETUP_INVENTSITEDEFAULT,INVENTITEMPURCHSETUP_LEADTIME,INVENTITEMPURCHSETUP_LOWESTQTY,INVENTITEMPURCHSETUP_MANDATORYINVENTSITE,INVENTITEMPURCHSETUP_MULTIPLEQTY,INVENTITEMPURCHSETUP_OVERRIDE,INVENTITEMPURCHSETUP_STANDARDQTY,INVENTITEMPURCHSETUP_STOPPED,INVENTITEMSAL_ATPBACKWARDDEMANDTIMEFENCE,INVENTITEMSAL_ATPBACKWARDSUPPLYTIMEFENCE,INVENTITEMSALES_ATPAPPLYDEMANDTIMEFENCE,INVENTITEMSALES_ATPAPPLYSUPPLYTIMEFENCE,INVENTITEMSALES_DELIVERYDATECONTROLTYPE,INVENTITEMSALESSETU_ATPINCLPLANNEDORDERS,INVENTITEMSALESSETUP_ATPTIMEFENCE,INVENTITEMSALESSETUP_HIGHESTQTY,INVENTITEMSALESSETUP_INVENTSITEDEFAULT,INVENTITEMSALESSETUP_LEADTIME,INVENTITEMSALESSETUP_LOWESTQTY,INVENTITEMSALESSETUP_MULTIPLEQTY,INVENTITEMSALESSETUP_OVERRIDE,INVENTITEMSALESSETUP_STANDARDQTY,INVENTMODULEINVENT_ALLOCATEMARKUP,INVENTMODULEINVENT_INTERCOMPANYBLOCKED,INVENTMODULEINVENT_MARKUP,INVENTMODULEINVENT_MARKUPGROUPID,INVENTMODULEPURCH_ALLOCATEMARKUP,INVENTMODULEPURCH_INTERCOMPANYBLOCKED,INVENTMODULEPURCH_MARKUP,INVENTMODULEPURCH_MARKUPGROUPID,INVENTMODULESALES_ALLOCATEMARKUP,INVENTMODULESALES_INTERCOMPANYBLOCKED,INVENTMODULESALES_MARKUP,INVENTMODULESALES_MARKUPGROUPID,ISREUSECONFIGURATIONENABLED,ISVARIANTGENERATIONENABLED,MANDATORYINVENTLOCATION,MANDATORYINVENTSITE,OVERRIDESALESLEADTIME,PDSCWMAX,PDSCWMIN,PDSCWUNITID,RETAILCOLORGROUPID,RETAILSIZEGROUPID,RETAILSTYLEGROUPID,STANDARDINVENTSTYLEID,STOPPED,UOMSEQGROUPID,WHSINVENTFIXED_INVENTSITEID,{fn CONVERT(WMSLOCATIONID,SQL_INTEGER)},{fn CONVERT(WHSRESERVATIONHIERARCHY_NAME,SQL_INTEGER)},0,0,'','','','',0,0,'',0,0,'',0,'',RECVERSION,PARTITION,RECID FROM DMFPRODUCTENTITY
Error Sincronizar base de datos No se puede ejecutar un comando de lenguaje de definición de datos en ().
La base de datos SQL ha emitido un error.
Información Sincronizar base de datos Descripción de error SQL: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the table 'DBO.X100479X', because it does not exist or you do not have permission.
Información Sincronizar base de datos Instrucción SQL: DROP TABLE "DBO".X100479X
Error Sincronizar base de datos No se puede ejecutar un comando de lenguaje de definición de datos en ().
La base de datos SQL ha emitido un error.
Any idea of how to solve them? I'm using AX 2012 R3 CU12, the table doesn't exist in AOT or in SQL, I already restart the servers and services (AOT and SQL), I ran full cil and compiled without errors, but when I run syncronization I'm still getting them.
