Teradata SQl Assistant Java Edition

Tools & Utilities
Teradata Employee

Teradata SQl Assistant Java Edition

Hi, i have downloaded SQLA JE and tried it to run but iam absolutly unble to run it. I alredy reisntalled JE to the newest version but it did not help. Does anyone has same problem?

Here is the first few rows from log file:

# A fatal error has been detected by the Java Runtime Environment:


#  EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x7c911669, pid=3900, tid=1772


# JRE version: 6.0_29-b11

# Java VM: Java HotSpot(TM) Client VM (20.4-b02 mixed mode, sharing windows-x86 )

# Problematic frame:

# C  [ntdll.dll+0x11669]


# If you would like to submit a bug report,

Thx for any help

Teradata Employee

Re: Teradata SQl Assistant Java Edition

We will need some more information about this problem in order to try to figure it out.

Could you provide more lines from the error log? There should be a list of Java class names (that start with things like "org.eclipse" or "com.teradata"). It would be useful to see more of how the program got to the point where the access violation occurred.

Do you get a message box displayed when the error occurs or does it simply not start at all?

What is the log file's name that you're showing us?

What is the environment you're running on? Is it a 32-bit or 64-bit system. What version of Windows? 

Teradata Employee

Re: Teradata SQl Assistant Java Edition


File is in root directory of TSQLA JE. Its named: hs_err_pid3900.log, below is full content of this file. I do not get any message box diplayed -> only logo will apperad and thats all.


# A fatal error has been detected by the Java Runtime Environment:


#  EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x7c911669, pid=3900, tid=1772


# JRE version: 6.0_29-b11

# Java VM: Java HotSpot(TM) Client VM (20.4-b02 mixed mode, sharing windows-x86 )

# Problematic frame:

# C  [ntdll.dll+0x11669]


# If you would like to submit a bug report, please visit:

#   http://java.sun.com/webapps/bugreport/crash.jsp


---------------  T H R E A D  ---------------

Current thread (0x02ca2400):  JavaThread "C1 CompilerThread0" daemon [_thread_in_native, id=1772, stack(0x03240000,0x03340000)]

siginfo: ExceptionCode=0xc0000005, reading address 0x0000242e


EAX=0x02c79788, EBX=0x003e0000, ECX=0x0000242e, EDX=0x02a16653

ESP=0x0333f5d0, EBP=0x0333f5dc, ESI=0x02c79780, EDI=0x02cd2000

EIP=0x7c911669, EFLAGS=0x00010246

Top of Stack: (sp=0x0333f5d0)

0x0333f5d0:   003e0000 00000008 003e0005 0333f614

0x0333f5e0:   7c91a3d5 0000242e 02cd2000 0333f608

0x0333f5f0:   00000000 00001000 02d11000 003e0000

0x0333f600:   00020005 000000e7 00001000 02c40000

0x0333f610:   003e0000 0333f844 7c911917 013e0000

0x0333f620:   00008000 00007ff4 00007ff4 03566008

0x0333f630:   042a3e70 0369c008 042a3df8 042a3cd0

0x0333f640:   0333f660 6d9f8fc0 00000000 03d30000

Instructions: (pc=0x7c911669)

0x7c911649:   3d 00 fe 00 00 0f 87 ad f0 ff ff 80 7d 14 00 0f

0x7c911659:   85 d2 7a 03 00 8b 4e 0c 8d 46 08 8b 10 89 4d 08

0x7c911669:   8b 09 3b 4a 04 89 55 0c 0f 85 9d 00 00 00 3b c8

0x7c911679:   0f 85 95 00 00 00 56 53 e8 de ef ff ff 8b 45 0c

Register to memory mapping:

EAX=0x02c79788 is an unknown value

EBX=0x003e0000 is an unknown value

ECX=0x0000242e is an unknown value

EDX=0x02a16653 is an unknown value

ESP=0x0333f5d0 is pointing into the stack for thread: 0x02ca2400

EBP=0x0333f5dc is pointing into the stack for thread: 0x02ca2400

ESI=0x02c79780 is an unknown value

EDI=0x02cd2000 is an unknown value

Stack: [0x03240000,0x03340000],  sp=0x0333f5d0,  free space=1021k

Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code)

C  [ntdll.dll+0x11669]  RtlInitializeCriticalSection+0x6c

C  [ntdll.dll+0x1a3d5]  RtlReAllocateHeap+0x855

C  [ntdll.dll+0x11917]  RtlInitializeCriticalSection+0x31a

C  [MSVCR71.dll+0x16b3]  _crtLCMapStringA+0x305

C  [MSVCR71.dll+0x16db]  _crtLCMapStringA+0x32d

V  [jvm.dll+0x53be3]

V  [jvm.dll+0x53e02]

V  [jvm.dll+0x54003]

V  [jvm.dll+0x151fa3]

V  [jvm.dll+0x1f4960]

V  [jvm.dll+0x1f7db8]

V  [jvm.dll+0x1f911a]

V  [jvm.dll+0x1f9f89]

V  [jvm.dll+0x1e3a79]

V  [jvm.dll+0x1e3b0c]

V  [jvm.dll+0x1e3c5f]

V  [jvm.dll+0x1e3eb4]

V  [jvm.dll+0x3dc4d]

V  [jvm.dll+0x3e77f]

V  [jvm.dll+0x118f14]

V  [jvm.dll+0x140fec]

C  [MSVCR71.dll+0x9565]  endthreadex+0xa0

C  [kernel32.dll+0xb713]  GetModuleFileNameA+0x1b4

Current CompileTask:

C1:   5656 782      com.ibm.icu.text.RuleBasedCollator.compareUseLatin1(Ljava/lang/String;Ljava/lang/String;I)I (1052 bytes)

---------------  P R O C E S S  ---------------

Java Threads: ( => current thread )

  0x03dce000 JavaThread "Worker-1" [_thread_blocked, id=1076, stack(0x05360000,0x05460000)]

  0x04463c00 JavaThread "Worker-0" [_thread_blocked, id=2148, stack(0x05260000,0x05360000)]

  0x03dc0400 JavaThread "Thread-2" [_thread_blocked, id=3756, stack(0x050e0000,0x051e0000)]

  0x03f76000 JavaThread "Worker-JM" [_thread_blocked, id=3780, stack(0x04aa0000,0x04ba0000)]

  0x040ce400 JavaThread "Bundle File Closer" daemon [_thread_blocked, id=4016, stack(0x041a0000,0x042a0000)]

  0x035c5400 JavaThread "Start Level Event Dispatcher" daemon [_thread_blocked, id=5092, stack(0x03b60000,0x03c60000)]

  0x035bb400 JavaThread "Framework Event Dispatcher" daemon [_thread_blocked, id=5272, stack(0x03a60000,0x03b60000)]

  0x035cd000 JavaThread "State Saver" [_thread_blocked, id=5296, stack(0x03960000,0x03a60000)]

  0x02ca8400 JavaThread "Low Memory Detector" daemon [_thread_blocked, id=3028, stack(0x03340000,0x03440000)]

=>0x02ca2400 JavaThread "C1 CompilerThread0" daemon [_thread_in_native, id=1772, stack(0x03240000,0x03340000)]

  0x02ca0800 JavaThread "Attach Listener" daemon [_thread_blocked, id=4440, stack(0x03140000,0x03240000)]

  0x02c9f400 JavaThread "Signal Dispatcher" daemon [_thread_blocked, id=3604, stack(0x03040000,0x03140000)]

  0x02c9bc00 JavaThread "Finalizer" daemon [_thread_blocked, id=3952, stack(0x02f40000,0x03040000)]

  0x02c97000 JavaThread "Reference Handler" daemon [_thread_blocked, id=5084, stack(0x02e40000,0x02f40000)]

  0x003e7000 JavaThread "main" [_thread_in_native, id=5108, stack(0x00030000,0x00130000)]

Other Threads:

  0x02c5ac00 VMThread [stack: 0x02d40000,0x02e40000] [id=1544]

  0x02cb3000 WatcherThread [stack: 0x03440000,0x03540000] [id=4300]

VM state:not at safepoint (normal execution)

VM Mutex/Monitor currently owned by a thread: None


 def new generation   total 78656K, used 21151K [0x169d0000, 0x1bf20000, 0x1bf20000)

  eden space 69952K,  18% used [0x169d0000, 0x1768d998, 0x1ae20000)

  from space 8704K,  93% used [0x1ae20000, 0x1b60a470, 0x1b6a0000)

  to   space 8704K,   0% used [0x1b6a0000, 0x1b6a0000, 0x1bf20000)

 tenured generation   total 174784K, used 0K [0x1bf20000, 0x269d0000, 0x269d0000)

   the space 174784K,   0% used [0x1bf20000, 0x1bf20000, 0x1bf20200, 0x269d0000)

 compacting perm gen  total 12288K, used 12019K [0x269d0000, 0x275d0000, 0x369d0000)

   the space 12288K,  97% used [0x269d0000, 0x2758cc98, 0x2758ce00, 0x275d0000)

    ro space 10240K,  51% used [0x369d0000, 0x36efd0b8, 0x36efd200, 0x373d0000)

    rw space 12288K,  54% used [0x373d0000, 0x37a69570, 0x37a69600, 0x37fd0000)

Code Cache  [0x009a0000, 0x00bc0000, 0x029a0000)

 total_blobs=982 nmethods=815 adapters=102 free_code_cache=31347520 largest_free_block=1728

Dynamic libraries:

0x00400000 - 0x0040d000     c:\Program Files\Teradata\Client\13.11\Teradata SQL Assistant Java Edition\sqlaje.exe

0x7c900000 - 0x7c9af000     C:\WINDOWS\system32\ntdll.dll

0x7c800000 - 0x7c8f6000     C:\WINDOWS\system32\kernel32.dll

0x7e410000 - 0x7e4a1000     C:\WINDOWS\system32\USER32.dll

0x77f10000 - 0x77f59000     C:\WINDOWS\system32\GDI32.dll

0x5d090000 - 0x5d12a000     C:\WINDOWS\system32\COMCTL32.dll

0x77dd0000 - 0x77e6b000     C:\WINDOWS\system32\ADVAPI32.dll

0x77e70000 - 0x77f02000     C:\WINDOWS\system32\RPCRT4.dll

0x77fe0000 - 0x77ff1000     C:\WINDOWS\system32\Secur32.dll

0x77c10000 - 0x77c68000     C:\WINDOWS\system32\MSVCRT.dll

0x76390000 - 0x763ad000     C:\WINDOWS\system32\IMM32.DLL

0x72000000 - 0x7200d000     c:\Program Files\Teradata\Client\13.11\Teradata SQL Assistant Java Edition\plugins\org.eclipse.equinox.launcher.win32.win32.x86_1.1.2.R36x_v20101222\eclipse_1312.dll

0x77c00000 - 0x77c08000     C:\WINDOWS\system32\VERSION.dll

0x6d7f0000 - 0x6da9f000     C:\Program Files\Java\jre6\bin\client\jvm.dll

0x76b40000 - 0x76b6d000     C:\WINDOWS\system32\WINMM.dll

0x7c340000 - 0x7c396000     C:\WINDOWS\system32\MSVCR71.dll

0x6d7a0000 - 0x6d7ac000     C:\Program Files\Java\jre6\bin\verify.dll

0x6d320000 - 0x6d33f000     C:\Program Files\Java\jre6\bin\java.dll

0x6d7e0000 - 0x6d7ef000     C:\Program Files\Java\jre6\bin\zip.dll

0x68000000 - 0x68036000     C:\WINDOWS\system32\rsaenh.dll

0x769c0000 - 0x76a74000     C:\WINDOWS\system32\USERENV.dll

0x5b860000 - 0x5b8b5000     C:\WINDOWS\system32\netapi32.dll

0x6d600000 - 0x6d613000     C:\Program Files\Java\jre6\bin\net.dll

0x71ab0000 - 0x71ac7000     C:\WINDOWS\system32\WS2_32.dll

0x71aa0000 - 0x71aa8000     C:\WINDOWS\system32\WS2HELP.dll

0x71a50000 - 0x71a8f000     C:\WINDOWS\System32\mswsock.dll

0x76f20000 - 0x76f47000     C:\WINDOWS\system32\DNSAPI.dll

0x76fb0000 - 0x76fb8000     C:\WINDOWS\System32\winrnr.dll

0x76f60000 - 0x76f8c000     C:\WINDOWS\system32\WLDAP32.dll

0x751d0000 - 0x751ee000     C:\WINDOWS\system32\wshbth.dll

0x77920000 - 0x77a13000     C:\WINDOWS\system32\SETUPAPI.dll

0x76fc0000 - 0x76fc6000     C:\WINDOWS\system32\rasadhlp.dll

0x74720000 - 0x7476c000     C:\WINDOWS\system32\MSCTF.dll

0x03840000 - 0x03849000     C:\ADVANC~1\wh_hook.dll

0x755c0000 - 0x755ee000     C:\WINDOWS\system32\msctfime.ime

0x774e0000 - 0x7761d000     C:\WINDOWS\system32\ole32.dll

0x6d620000 - 0x6d629000     C:\Program Files\Java\jre6\bin\nio.dll

0x605d0000 - 0x605d9000     C:\WINDOWS\system32\mslbui.dll

0x10000000 - 0x10063000     C:\Program Files\Teradata\Client\13.11\Teradata SQL Assistant Java Edition\configuration\org.eclipse.osgi\bundles\168\1\.cp\swt-win32-3659.dll

0x77120000 - 0x771ab000     C:\WINDOWS\system32\OLEAUT32.dll

0x763b0000 - 0x763f9000     C:\WINDOWS\system32\comdlg32.dll

0x773d0000 - 0x774d3000     C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.5512_x-ww_35d4ce83\COMCTL32.dll

0x77f60000 - 0x77fd6000     C:\WINDOWS\system32\SHLWAPI.dll

0x7c9c0000 - 0x7d1d7000     C:\WINDOWS\system32\SHELL32.dll

0x74d90000 - 0x74dfb000     C:\WINDOWS\system32\USP10.dll

0x3d930000 - 0x3da16000     C:\WINDOWS\system32\WININET.dll

0x03d00000 - 0x03d09000     C:\WINDOWS\system32\Normaliz.dll

0x78130000 - 0x78263000     C:\WINDOWS\system32\urlmon.dll

0x3dfd0000 - 0x3e1b9000     C:\WINDOWS\system32\iertutil.dll

0x04dd0000 - 0x04ded000     C:\Program Files\Teradata\Client\13.11\Teradata SQL Assistant Java Edition\configuration\org.eclipse.osgi\bundles\168\1\.cp\swt-gdip-win32-3659.dll

0x4ec50000 - 0x4edfb000     C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.6002.22509_x-ww_c7dad023\gdiplus.dll

0x5ad70000 - 0x5ada8000     C:\WINDOWS\system32\uxtheme.dll

0x04f30000 - 0x04f3e000     C:\Program Files\Teradata\Client\13.11\Teradata SQL Assistant Java Edition\configuration\org.eclipse.osgi\bundles\54\1\.cp\os\win32\x86\localfile_1_0_0.dll

0x76bf0000 - 0x76bfb000     C:\WINDOWS\system32\PSAPI.DLL

VM Arguments:

jvm_args: -Dosgi.requiredJavaVersion=1.6 -Xms256m -Xmx256m -XX:MaxPermSize=256m

java_command: <unknown>

Launcher Type: generic

---------------  S Y S T E M  ---------------

OS: Windows XP Build 2600 Service Pack 3

CPU:total 2 (2 cores per cpu, 1 threads per core) family 6 model 15 stepping 13, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3

Memory: 4k page, physical 3135384k(1752088k free), swap 6111592k(4569476k free)

vm_info: Java HotSpot(TM) Client VM (20.4-b02) for windows-x86 JRE (1.6.0_29-b11), built on Oct  3 2011 01:01:08 by "java_re" with MS VC++ 7.1 (VS2003)

time: Wed Oct 26 13:33:40 2011

elapsed time: 5 seconds

Teradata Employee

Re: Teradata SQl Assistant Java Edition

I have run the program with the same Java runtime environment as you and have no problems. The stack you've attached doesn't seem to show that any Java code is involved at the time of the error. You say that you see "the logo appeared." Does that mean you see the orange window with the glasses?

It doesn't seem to be a problem with the permissions to write to the program's workspace. If that were the case it should give a message saying that it couldn't write the files. The shortcut that launches the program sets the working directory to the the evaluation of the environment variables: %HOMEDRIVE%%HOMEPATH%

Are those two environment variables set to a location where you've got permission to write?

All the dll names in the stack are from Windows or Java, none are from our program. Is it possible that the Java runtime has gotten corrupted?

Teradata Employee

Re: Teradata SQl Assistant Java Edition

Well i do not underestand that, but suddenly it started to work....and i did not do anything.

Thx for help