[andrewteg]

Know it’s a couple months old but I found in sja.log “You can’t use locks with log tables.” and had to not lock tables to get a successful email message. Just check the XML for locktableread. Mine was yes and changing to no fixed it for me. My guess is if something is in the log it will say unsuccessful.

[andrewteg]

Thanks guys. SJA is working fine!

I did not realize that 8.23.2 installed separately to just “SQLyog” and when I was running SJA on the command line I was using “SQLyog Enterprise” so it was using SJA 8.18. When I updated the path to the new SJA at “SQLyog” it used SJA 8.23.2 and that worked great!

Thanks,

Andrew

[andrewteg]

Thank you for such a quick response!

I have tried the special build 8.23.2 in my local environment and am able to import the full strings through Powertools > Import External Data. This works quite well! It works equally well for me using both MyISAM and InnoDB tables.

When I save the job and run it through the SQLyog Job Agent on the command line such as

Code:

“C:Program Files (x86)SQLyog Enterprisesja.exe” “C:import.xml”

data is truncating through that. This may be expected since you may have just updated the Import External Data process and not the SJA yet. But I did want to let you know in case this was a surprise to you.

Thanks so much!

Andrew

[andrewteg]

Quote:

1. Can you please tell whether this truncation of data is for a specific data type or for all?

It appears to be doing it for varchar and text fields. So far, I have not seen it on numeric values, but my sample data does not have any large numeric values.

Quote:

2. Which UniVerse database you are using Ardent Universe Database or IBM Universe Database?

I am using “UniVerse Personal Edition for Windows” from http://rocketsoftware.com/u2/downloads/ for my development and testing. This is basically the IBM UniVerse since “Rocket acquired the IBM UniVerse and UniData (U2) product line on October 1, 2009” according to http://www.ibm.com/software/data/u2

Quote:

3. Have you tried to import data from UniVerse database to MS Access? Is it also truncating data?

Yes and I have imported data to MS Access (using linked tables) and it is not truncating the data.

Quote:

Thanks & Regards,

Khushboo

Thanks so much, and please let me know if I can do anything to help!

Andrew

[andrewteg]

Thanks! You're absolutely right and apparently I need to learn how to read 😮

It is working exactly as the FAQ claims. Thanks again.

[andrewteg]

I didn't know that. Combined with the Refresh button that's great!

Thanks!

[Author]

Posts