cerb3-to-cerb4-migration-tools Error

[RossMac]

Just ran the cerb3-to-cerb4-migration-tools as root, everyone has read/write permissions in /tmp and received the following messages

java.sql.SQLException: Error writing file '/tmp/MY9FxOxL' (Errcode: 28)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2934)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 16)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1708)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 3249)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 3178)
at com.mysql.jdbc.Statement.executeQuery(Statement.ja va:1203)
at com.webgroupmedia.Cerb3Exporter.main(Cerb3Exporter .java:219)


any ideas
Many Thanks in advance
Ross

[bcavish]

Hi Ross,

I would check and make sure that all the files in the /tmp directory have the same ownership as the user you are running the migration tool with. Also, I'd make sure you use chmod and chown -R

Brenan

[RossMac]

Thanks for you assistance,
as I said, I am running the command as root and root has full permissions in the tmp folder.
Many Thanks
Ross

[RossMac]

Not sure if this is relevant but to get to this point we ran each upgrade script from 2.7 to 3.6 we had no problems until 3.6 when the verification script gave us this warning.

Verifying index skill_to_agent.has_skill ... WARNING: index_fields is (has_skill) should be (has_skill,agent_id): not found!

This is the only problem we have encountered but wonder if it is relevant to the problems we are having using the cerb3 to cerb4 migration tool.

Once again, many thanks for the assistance.
Ross

[mdc]

Was all running fine on on Wintel box

Since running the Migration tool, parsing of both the imported messages and any new messages doesn't work

No errors as such

Time Limit: unlimited secs
Memory Limit: 64M

Reading A000000015.msg...
Decoding... decoded! (9 ms)
Parsing... parsed! (0 ms) (Ticket ID: )

--------------------------------------------------------------------------------
Reading A000000016.msg...
Decoding... decoded! (1 ms)
Parsing... parsed! (0 ms) (Ticket ID: )

--------------------------------------------------------------------------------
Reading A000000017.msg...
Decoding... decoded! (1 ms)
Parsing... parsed! (0 ms) (Ticket ID: )

.... and more obviously only 50 ish tickets in the list


HELP !! - this is my live helpdesk system

[jstanden]

@Rossmac:
OS error code 28: No space left on device (your /tmp is full)

@mdc:
Send a message to support(AT)webgroupmedia.com if you're able to provide us with access to assist you in migrating to Cerb4. It sounds like you don't have a complete Cerb4 installation before importing.