Impex import password field

[Former Member]

Hi experts We are in a migration project from 5.2 to 6.5, we already put the 6.5 version. we are trying import B2BCustomer and we have an error with the password field, we are using mySQL as database

This is the error in the log:

WARN [impex result worker [cj:00004S5Q ]] [ImpExImportReader] line 3 at main script: dumped unresolved line ValueLine[u nresolvable:Exception : line 2: cannot create B2BCustomer with values ItemAttrib uteMap[ registry: null, type: , data: {password=1234, groups=[b2bmanagerg roup[8796093382661], b2bcustomergroup[8796256960517], b2badmingroup[879609331712 5], 13311[8796224192517]], sessioncurrency=8796093120545->USD, domain=impex doma in, uid=impexTestB2BCustomer, description=null, email=impexText@enapsys.com, nam e=ImpexTestCustomer} ] due to org.springframework.dao.DataIntegrityViolationExce ption: query; SQL []; Data truncation: Data too long for column 'passwd' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'passwd' at row 1, transaction rolled back because it has b een marked as rollback-only, Exception : line 3: cannot create B2BCustomer with values ItemAttributeMap[ registry: null, type: , data: {password=1234, gr oups=[b2bmanagergroup[8796093382661], b2bcustomergroup[8796256960517], b2badming roup[8796093317125], 13311[8796224192517]], sessioncurrency=8796093120545->USD, domain=impex domain, uid=impexTestB2BCustomer, description=null, email=impexText @enapsys.com, name=ImpexTestCustomer} ] due to org.springframework.dao.DataInteg rityViolationException: query; SQL []; Data truncation: Data too long for column 'passwd' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'passwd' at row 1,line 3 at main script,nu ll,HeaderDescriptor[line 2 at main script, insert_update, B2BCustomer, {}, [desc ription, uid, email, name, domain, groups, sessionCurrency, password] ],{1=Value Entry(''=null,unresolved=false,ignore=false), 2=ValueEntry('impexTestB2BCustomer '=impexTestB2BCustomer,unresolved=false,ignore=false), 3=ValueEntry('impexText@e napsys.com'=impexText@enapsys.com,unresolved=false,ignore=false), 4=ValueEntry(' ImpexTestCustomer'=ImpexTestCustomer,unresolved=false,ignore=false), 5=ValueEntr y('impex domain'=impex domain,unresolved=false,ignore=false), 6=ValueEntry('b2bm anagergroup,b2bcustomergroup,b2badmingroup,13311'=[b2bmanagergroup[8796093382661 ], b2bcustomergroup[8796256960517], b2badmingroup[8796093317125], 13311[87962241 92517]],unresolved=false,ignore=false), 7=ValueEntry(''=8796093120545->USD,unres olved=false,ignore=false), 8=ValueEntry('1234'=1234,unresolved=false,ignore=fals e)}]

We ran an update to the system, we also check the structure of the field in mySql it shows the field as varchar(255)

Thanks for your help

[Former Member]

Hi Adán,

The error shows that there was a problem with validation of SQL command that was sent to the database as the value of ‘password’ was too long. It would be good to check JDBC log and put some more light on the value database actually received. It may have been hashed with Sha-256, Sha-384 or Sha-512 that are popular in SSL/TSL or salted and encoded in any other way, depends on applied customization.

 Access JDBC logging:
 
 1. Go to HAC -> Access Monitoring-> Database-> JDBC Logging.
 2. Click ‘Enable Logging’ and ‘Start Logging’.
 3. Re-import Impex to cause the error.
 4. Back in HAC click “Download log”.

Look for Insert/Update that your Impex created and password value.

Best Regards,