500 (Internal Server Error) CreateTab ContentStorage, connect error SQLConn

[Former Member]

Hi,

When i try to connect to the content server i get the following error.[Maxdb is on windows 2003 server.]

http://strap1346.crop.trep.org:1090/ContentServer/ContentServer.dll?get&pVersion=0046&contRep=D2&doc...

Error:

500 (Internal Server Error)

CreateTab ContentStorage, connect error SQLConnect failed, Specified driver could not be loaded due to system error 193 (MaxDB)., Error Code: 160

Thanks,

Rajiv

[Former Member · Accepted solution]

Please check knldiag file for more details. and use the command xsysrc <rc> to get the error details.

[Former Member · Accepted solution]

How do we chk that file?

I did the following and i got this message

C:\sdb\programs\bin>xsysrc 193

Errortext for errorcode 193:

'No system errortext for ERRNO 193'

[Former Member · Accepted solution]

logon to your content server and File located in the database RUNDIRECTORY.

or use the database manager tool --> logon to your DB --> under check --> Diagnosis Files --> KNLDIAG (database errors)

[Former Member · Accepted solution]

i checked that file.I could not find any errors there.

[Former Member · Accepted solution]

Opps ! I mean database messages (make sure you click on action --> find current write position). please paste last 20 lines.

[Former Member · Accepted solution]

---

Date Time TID(hex) Typ MsgID Label Message-Text

-

---

2010-10-12 16:14:36 0x135C 19839 DIAGHIST Backup of diagnostic files is in progress

2010-10-12 16:14:36 0x135C 19840 DIAGHIST Backup of diagnostic files has ended successfully

2010-10-12 16:14:36 0x135C 19692 TCLUSTER tw;al;ut;2000sv,100bup;10ev,10gc;ti,100dw,cs;30000us;compress

2010-10-12 16:14:36 0x135C 19693 TCLUSTER number of 'BUP': 0

2010-10-12 16:14:36 0x135C 19693 TCLUSTER number of ' DW': 8

2010-10-12 16:14:36 0x135C 19693 TCLUSTER number of ' US': 1

2010-10-12 16:14:36 0x135C 19693 TCLUSTER number of ' SV': 11

2010-10-12 16:14:36 0x135C 19693 TCLUSTER number of ' EV': 0

2010-10-12 16:14:36 0x135C 19693 TCLUSTER number of ' GC': 0

2010-10-12 16:14:36 0x135C 19811 EVENTING Suppressing output to 'knldiag.evt' 0 pages

2010-10-12 16:14:36 0x135C 19813 EVENTING No Eventbuffer created (0 entries 100 tasks)

2010-10-12 16:14:36 0x135C 19769 INFO Starting SERVERDB: '_CSAPDBS'

2010-10-12 16:14:36 0x135C 19770 INFO SERVERNODE: 'CINDS2507.CORP.interstatebrands.org'

2010-10-12 16:14:36 0x135C 19771 INFO Process ID: 1728

2010-10-12 16:14:36 0x135C 19773 INFO Date: 10-10-12

2010-10-12 16:14:36 0x135C 19772 INFO Owner: 'SYSTEM'

2010-10-12 16:14:36 0x135C 19774 INFO Product suite: 'Enterprise'

2010-10-12 16:14:36 0x135C 19775 INFO Number of Processors: 4

2010-10-12 16:14:36 0x135C 19782 INFO Fiber: 'NO'

2010-10-12 16:14:36 0x135C 19776 INFO Max virtual memory: 4095 MB

2010-10-12 16:14:36 0x135C 19777 INFO Total physical memory: 4093 MB

2010-10-12 16:14:36 0x135C 19778 INFO Available physical memory: 3277 MB

2010-10-12 16:14:36 0x135C 19779 INFO Kernel shared data size: 5 MB

2010-10-12 16:14:36 0x135C 19837 MEMORY 234 Pages allocated for SHAREDDYNDATA at 0x02350000

2010-10-12 16:14:36 0x135C 19837 MEMORY 2 Pages allocated for CONVERTER CACHE at 0x02530000

2010-10-12 16:14:36 0x135C 19837 MEMORY 262 Pages allocated for SHAREDDYNPOOL at 0x02540000

2010-10-12 16:14:36 0x135C 19831 TRACE_IO Configured MAXMESSAGE_FILES:0

2010-10-12 16:14:36 0x135C 19832 TRACE_IO Disabled: No TraceMessagefiles wanted

2010-10-12 16:14:36 0x6D0 19688 THREAD CLOCK thread started

2010-10-12 16:14:36 0x1070 19688 THREAD TIMER thread started

2010-10-12 16:14:36 0x2D8 19688 THREAD ASYNC0 thread started

2010-10-12 16:14:36 0xB04 19688 THREAD DCOM0 thread started

2010-10-12 16:14:36 0x290 19688 THREAD CONSOLE thread started

2010-10-12 16:14:36 0x1378 19688 THREAD REQUESTOR thread started

2010-10-12 16:14:36 0x1314 19627 TASKING UKT started, TID:0x1314

2010-10-12 16:14:36 0x2FC 19627 TASKING UKT started, TID:0x2FC

2010-10-12 16:14:36 0x194 19627 TASKING UKT started, TID:0x194

2010-10-12 16:14:36 0x458 19627 TASKING UKT started, TID:0x458

2010-10-12 16:14:36 0x1204 19627 TASKING UKT started, TID:0x1204

2010-10-12 16:14:36 0x9B4 19627 TASKING UKT started, TID:0x9B4

2010-10-12 16:14:36 0x9B4 19615 DEVIO Attaching devspace 'knltrace'

2010-10-12 16:14:36 0xFE0 19613 DBSTATE I/O thread for 'knltrace' started

2010-10-12 16:14:36 0x9B4 54003 dynpool NUM DATAWRITER : 8

2010-10-12 16:14:36 0x9B4 54003 dynpool DATAWRITER task desc : 12

2010-10-12 16:14:36 0x9B4 54003 dynpool DATAWRITER cache list : 8

2010-10-12 16:14:36 0x9B4 54003 dynpool DYNP_B12_DATA_WRIT : 160

2010-10-12 16:14:36 0x9B4 54003 dynDATA DYND_B15_CONFIG : 3

2010-10-12 16:14:36 0x9B4 54003 dynpool DYNP_B15_DEV_DESC : 72

2010-10-12 16:14:36 0x9B4 54003 dynpool PHYS_SYS_DEV_DESCR : 24

2010-10-12 16:14:36 0x9B4 54003 dynpool PHYS_DATA_DEV_DESCR : 24

2010-10-12 16:14:36 0x9B4 54003 dynpool PHYS_LOG_DEV_DESCR : 24

2010-10-12 16:14:36 0x9B4 54003 dynpool DYNP_A51_CACHE : 56

2010-10-12 16:14:36 0x9B4 54003 dynpool AK51SIZES user + 1 : 2

2010-10-12 16:14:36 0x9B4 54003 dynpool AK51SIZES headlist all : 8

2010-10-12 16:14:36 0x9B4 54003 dynpool AK51SIZES headlist elem: 4

2010-10-12 16:14:36 0x9B4 54003 dynpool AK51SIZES list all : 48

2010-10-12 16:14:36 0x9B4 54003 dynpool AK51SIZES list element : 24

2010-10-12 16:14:36 0x9B4 54003 dynpool entries per FBM page : 16352

2010-10-12 16:14:36 0x9B4 54003 dynpool FBM_GLOBAL_STRUCT total: 124

2010-10-12 16:14:36 0x9B4 54003 dynpool FBM_DEV_INFO total : 416

2010-10-12 16:14:36 0x9B4 54003 dynpool MAX_DATA_DEVSPACES : 2

2010-10-12 16:14:36 0x9B4 54003 dynpool FBM_DEVINFO element : 208

2010-10-12 16:14:36 0x9B4 54003 dynDATA DYND_B11_FBM_CACHE : 1

2010-10-12 16:14:36 0x9B4 54003 dynpool FBM_DIRTY_LIST total : 1

2010-10-12 16:14:36 0x9B4 54003 dynpool MAX_FBM_PNO : 1

2010-10-12 16:14:36 0x9B4 54003 dynpool FBM_DIRTY element : 1

2010-10-12 16:14:36 0x9B4 54003 dynpool FBM_BUP_PNO_LIST total : 752

2010-10-12 16:14:36 0x9B4 54003 dynpool DYNP_B11_FBM_STRUC : 1293

2010-10-12 16:14:36 0x9B4 19600 VERSION 'Kernel 7.3.0 Build 042-000-092-102'

2010-10-12 16:14:36 0x9B4 19600 VERSION 'NT/INTEL 7.3.0 Build 042-000-092-102'

2010-10-12 16:14:36 0x9B4 54003 dynDATA DYND_K57_KB_PAGES : 11

2010-10-12 16:14:36 0x9B4 54003 dynpool LOG_CACHE elements : 16

2010-10-12 16:14:36 0x9B4 54003 dynpool DYNP_K56_LOG_CACHE : 64

2010-10-12 16:14:36 0x9B4 54003 dynDATA DYND_K56_LOG_CACHE : 17

2010-10-12 16:14:36 0x9B4 54003 dynpool DYNP_K562_TRANSLST : 2352

2010-10-12 16:14:36 0x9B4 54003 dynpool LOG_CACHE maxtrans : 14

2010-10-12 16:14:36 0x9B4 54003 dynpool LOG_CACHE trans_entry : 168

2010-10-12 16:14:36 0x9B4 54003 dynpool DYNP_K55_PID_LIST : 112

2010-10-12 16:14:36 0x9B4 54003 dynpool LOG_QUEUE tasks : 14

2010-10-12 16:14:36 0x9B4 54003 dynpool LOG_QUEUE TASKENTRYsize: 8

2010-10-12 16:14:36 0x9B4 54003 dynDATA DYND_K55_LOG_QUEUE : 50

2010-10-12 16:14:36 0x9B4 54003 dynpool DYNP_K55_LOG_QUEUE : 2000

2010-10-12 16:14:36 0x9B4 54003 dynpool LOG_QUEUE entries : 50

2010-10-12 16:14:36 0x9B4 54003 dynpool LOG_QUEUE entry size : 40

2010-10-12 16:14:36 0x9B4 54003 dynDATA BACKUP RESTART REC (4K): 1

2010-10-12 16:14:36 0x9B4 54003 dynpool BACKUP TASK LIST : 48

2010-10-12 16:14:36 0x9B4 54003 dynpool BACKUP TAPE LIST : 288

2010-10-12 16:14:36 0x9B4 54003 dynpool BACKUP DEVSP LIST : 16

2010-10-12 16:14:36 0x9B4 54003 dynpool BACKUP SRR QUEUE : 224

2010-10-12 16:14:36 0x9B4 54003 dynpool DYNP_K38_SAVE_GLOB : 576

2010-10-12 16:14:36 0x9B4 54003 dynDATA DYND_K38_SAVE : 73

2010-10-12 16:14:36 0x9B4 54003 dynDATA BACKUP RESTART REC (4K): 1

2010-10-12 16:14:36 0x9B4 54003 dynpool BACKUP TASK LIST : 32

2010-10-12 16:14:36 0x9B4 54003 dynpool BACKUP TAPE LIST : 288

2010-10-12 16:14:36 0x9B4 54003 dynpool BACKUP DEVSP LIST : 16

2010-10-12 16:14:36 0x9B4 54003 dynpool BACKUP SRR QUEUE : 128

2010-10-12 16:14:36 0x9B4 54003 dynpool DYNP_K38_AUTOSAVE : 464

2010-10-12 16:14:36 0x9B4 54003 dynDATA DYND_K38_AUTOSAVE : 41

2010-10-12 16:14:36 0x9B4 54003 dynpool KB50 mdesc item size : 216

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 mdesc items : 15

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 mdesc list size : 3240

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 mdesc list aligned: 3248

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 packet items : 12

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 packet desc size : 16

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 packet desc list : 192

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 packet size : 36672

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 packetsize aligned: 36672

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 packet list : 440064

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 parent list : 336

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 kbfunction_task : 14

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 parent items / 0.7: 20

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 parent desc size : 16

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 parentdesc aligned: 320

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 parent hash list : 80

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 parenthash aligned: 80

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 maxservertasks : 11

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 server desc size : 24

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 server list : 264

2010-10-12 16:14:36 0x9B4 54003 dynpool KB90 serverlist aligned: 272

2010-10-12 16:14:36 0x9B4 54003 dynpool DYNP_K90_DISTRIB : 444176

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT start pid: 13

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT first datacache: 0

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT start pid: 12

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT first datacache: 1

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT start pid: 11

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT first datacache: 2

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT start pid: 10

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT first datacache: 3

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT start pid: 9

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT first datacache: 4

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT start pid: 8

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT first datacache: 5

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT start pid: 7

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT first datacache: 6

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT start pid: 6

2010-10-12 16:14:36 0x9B4 53040 I/O DATAWRIT first datacache: 7

2010-10-12 16:14:37 0x1070 19601 DBSTATE SERVERDB is ready

============================================ begin of write cycle ==================

2010-10-13 12:22:29 0x135C 19611 DBSTATE SERVERDB is being stopped

2010-10-13 12:22:29 0x135C 19684 TASKING Tracewriter termination timeout: 1200 sec

2010-10-13 12:22:29 0x1314 19617 DEVIO Single I/O attach, 'knltrace', UKT:1

2010-10-13 12:22:29 0x1314 19619 TASKING Releasing tracewriter

2010-10-13 12:22:29 0x135C 19600 VERSION 'Kernel 7.3.0 Build 042-000-092-102'

2010-10-13 12:22:29 0x135C 19654 DBSTATE SERVERDB '_CSAPDBS' has stopped

-

---

current write position -

---

[Former Member · Accepted solution]

>>2010-10-13 12:22:29 0x1314 19617 DEVIO Single I/O attach

Mean you your DB is down. Can you please make sure that all the datafile / logfile are available?

[Former Member · Accepted solution]

Here is the latest file:

============================================ begin of write cycle ==================

2010-11-24 16:30:55 0x1108 19633 CONNECT Connect req. (T223, Node:'', PID:4632)

2010-11-24 16:30:56 0x12C0 19633 CONNECT Connect req. (T69, Node:'', PID:4196)

2010-11-24 16:30:56 0x12C0 19615 VOLUMEIO Attaching volume 'C:\Documents and Settings\All Users\Application Data\sdb\data\SDB\data\DISKD0001'

2010-11-24 16:30:56 0x112C 19613 DBSTATE I/O thread for 'C:\Documents and Settings\All Users\Application Data\sdb\data\SDB\data\DISKD0001' started

2010-11-24 16:30:56 0x12C0 19617 VOLUMEIO Single I/O attach, 'C:\Documents and Settings\All Users\Application Data\sdb\data\SDB\data\DISKD0001', UKT:7

2010-11-24 16:30:56 0x12C0 19615 VOLUMEIO Attaching volume 'F:\sapdb\SDB\sapdata\DISKD0002'

2010-11-24 16:30:56 0x1170 19613 DBSTATE I/O thread for 'F:\sapdb\SDB\sapdata\DISKD0002' started

2010-11-24 16:30:56 0x12C0 19617 VOLUMEIO Single I/O attach, 'F:\sapdb\SDB\sapdata\DISKD0002', UKT:7

2010-11-24 16:30:56 0x12C0 19615 VOLUMEIO Attaching volume 'G:\sapdb\SDB\saplog\DISKLOG001'

2010-11-24 16:30:56 0x1020 19613 DBSTATE I/O thread for 'G:\sapdb\SDB\saplog\DISKLOG001' started

2010-11-24 16:30:56 0x12C0 19617 VOLUMEIO Single I/O attach, 'G:\sapdb\SDB\saplog\DISKLOG001', UKT:7

2010-11-24 16:30:56 0x12C0 20016 Pager Start Read Converter

2010-11-24 16:30:57 0x12C0 20017 Pager Stop Read Converter, Pages: 731 IO: 731

2010-11-24 16:30:57 0x12C0 53000 DATACACH Begin data cache restart

2010-11-24 16:30:57 0x12C0 54003 dynpool DATACACHE STRIPES : 32

2010-11-24 16:30:57 0x12C0 54003 dynpool DATACACHE HASH LIST : 181904

2010-11-24 16:30:57 0x12C0 54003 dynpool DATACACHE head items : 11369

2010-11-24 16:30:57 0x12C0 54003 dynpool DATACACHE head item siz: 16

2010-11-24 16:30:57 0x12C0 54003 dynpool DATACACHE TASK QUEUE : 9160

2010-11-24 16:30:57 0x12C0 54003 dynpool DATACACHE taskq items : 229

2010-11-24 16:30:57 0x12C0 54003 dynpool DATACACHE taskq size : 40

2010-11-24 16:30:57 0x12C0 54003 dynpool DATACACHE CONTROLBLOCKS: 363392

2010-11-24 16:30:57 0x12C0 54003 dynpool DATACACHE num cblocks : 2839

2010-11-24 16:30:57 0x12C0 54003 dynpool DATACACHE cblock size : 128

2010-11-24 16:30:57 0x12C0 54003 dynpool DYNP_B20_DATACACHE : 17742592

2010-11-24 16:30:57 0x12C0 54003 dynDATA DYND_B20_DATACACHE : 90848

2010-11-24 16:30:57 0x12C0 53000 DATACACH Finish data cache restart

2010-11-24 16:30:57 0x12C0 53000 B*TREE LOB file directory restart successful

2010-11-24 16:30:57 0x12C0 7 FileDir File directory restarting

2010-11-24 16:30:57 0x12C0 8 FileDir File directory restart completed

2010-11-24 16:30:57 0x12C0 20061 Log History: 20 (20) files existing

2010-11-24 16:30:57 0x12C0 20064 Log History: all history files registered, GC is ready

2010-11-24 16:30:57 0x12C0 54003 dynpool DYNP_K51_LOCK_LIST :1390784

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK maxlocks : 4040

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK items : 14600

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK Regions : 24

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK TransRegions : 8

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK RegionGlob+Space : 3840

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK TransGlob : 768

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK SupplyItemsPerRgn : 100

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK SupplySize : 211200

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK RowHash entries : 4040

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK TabHash entries : 808

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK Row+Tab hash size : 38912

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK Trans entries : 168

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK trans_list size : 45696

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK TransPtrList : 1344

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK TransHash entries : 168

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK TransHash size : 1408

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK SupplyPoolSegments: 122

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK SupplyPoolSize :1076528

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK ObjColl_list size : 5376

2010-11-24 16:30:57 0x12C0 54003 dynpool LOCK ObjReq_list size : 3360

2010-11-24 16:30:57 0x12C0 20006 Log 0 queues, flushmode is 'MaximizeSafety', devstate is 'Okay'

2010-11-24 16:30:57 0x12C0 20007 Log Oldest not saved is ioseq NIL @ off 1

2010-11-24 16:30:57 0x12C0 20008 Log First known on LogVolume is ioseq 0 @ off 1

2010-11-24 16:30:57 0x12C0 20005 Log Restart from ioseq 4 @ off 5 to ioseq 4 @ off 5

2010-11-24 16:30:57 0x12C0 20010 Log Result after checking the log device: 'Ok'

2010-11-24 16:30:57 0x12C0 9 Log The number of active logging-queues has been increased to 2

2010-11-24 16:30:57 0x12C0 53000 OBJECT Restarted Garbage coll: 0

2010-11-24 16:30:57 0x12C0 11 Rst 168 redo transactions readable and 32 redo tasks available.

2010-11-24 16:30:57 0xF68 7 Restart recovering log from log_volume from IOSeq: '4'

2010-11-24 16:30:57 0xF68 20044 Log normal end of log found at off 5 lastseq 4.

2010-11-24 16:30:57 0xF68 20012 Log last-redo-read empty errlist#1:TR4294967295(156)[4]@5.24'SavepointEntry':20101124:163009

2010-11-24 16:30:57 0xF68 1 Savepoin Savepoint (Distance) started by T89

2010-11-24 16:30:57 0xF68 20004 Pager SVP(1) Start Write Data

2010-11-24 16:30:57 0xF68 20005 Pager SVP(1) Stop Data IO, Pages: 20 IO: 13

2010-11-24 16:30:57 0xF68 20006 Pager SVP(2) Wait for last task: 154

2010-11-24 16:30:57 0xF68 20007 Pager SVP(2) Stop Wait for last task, Pages: 0 IO: 0

[Former Member · Accepted solution]

2010-11-24 16:30:57 0xF68 53070 SAVPOINT B20PREPARE_SVP: 2611

2010-11-24 16:30:57 0xF68 20008 Pager SVP(3) Start Write Data

2010-11-24 16:30:57 0xF68 20009 Pager SVP(3) Stop Data IO, Pages: 2 IO: 2

2010-11-24 16:30:57 0xF68 20010 Pager SVP(3) Start Write Converter

2010-11-24 16:30:57 0xF68 20011 Pager SVP(3) Stop Converter IO, Pages: 11 IO: 11

2010-11-24 16:30:57 0xF68 53071 SAVPOINT B20SVP_COMPLETED: 2611

2010-11-24 16:30:57 0x12C0 5 Rst RedoControl: End of redo processing

2010-11-24 16:30:57 0x12C0 4 Rst + RedoControl: OldestCommitSeq: NIL, RedoTasks: 32 , MaxRedoTrans: 168

2010-11-24 16:30:57 0x12C0 6 Rst + RedoControl: EndOfLogReached: true, RedoIsAborted: false, RedoProcessingDisabled: false

2010-11-24 16:30:57 0x12C0 12 Rst + RedoControl: redo reader T0 wait reason: isNotWaiting, waiting redo executer: 0

2010-11-24 16:30:57 0x12C0 8 Rst + RedoControl: Transactions processed: 0 (0)

2010-11-24 16:30:57 0x12C0 1 Savepoin Savepoint (Restart) started by T69

2010-11-24 16:30:57 0xF68 20004 Pager SVP(1) Start Write Data

2010-11-24 16:30:57 0xF68 20005 Pager SVP(1) Stop Data IO, Pages: 3 IO: 3

2010-11-24 16:30:57 0xF68 20006 Pager SVP(2) Wait for last task: 154

2010-11-24 16:30:57 0xF68 20007 Pager SVP(2) Stop Wait for last task, Pages: 0 IO: 0

2010-11-24 16:30:57 0xF68 53070 SAVPOINT B20PREPARE_SVP: 2612

2010-11-24 16:30:57 0xF68 20008 Pager SVP(3) Start Write Data

2010-11-24 16:30:57 0xF68 20009 Pager SVP(3) Stop Data IO, Pages: 2 IO: 2

2010-11-24 16:30:57 0xF68 20010 Pager SVP(3) Start Write Converter

2010-11-24 16:30:57 0xF68 20011 Pager SVP(3) Stop Converter IO, Pages: 5 IO: 5

2010-11-24 16:30:57 0xF68 53071 SAVPOINT B20SVP_COMPLETED: 2612

2010-11-24 16:30:57 0x12C0 20039 Admin Kernel state: 'REDO LOG' finished

2010-11-24 16:30:57 0x12C0 54000 OBJECT C:\Program Files\maxdb\SDB\pgm\liboms

2010-11-24 16:30:57 0x12C0 3 RunTime State changed from ADMIN to ONLINE

2010-11-24 16:30:57 0x12C0 20218 RTE Used physical memory 1091 MByte

2010-11-24 16:30:57 0x12C0 20041 Admin Kernel state: 'ONLINE' reached

2010-11-24 16:30:57 0x12C0 19651 CONNECT Connection released, T69

2010-11-24 16:30:57 0x12C0 19633 CONNECT Connect req. (T70, Node:'', PID:4196)

2010-11-24 16:30:58 0x1288 19633 CONNECT Connect req. (T79, Node:'', PID:4632)

2010-11-24 16:30:58 0x1288 19651 CONNECT Connection released, T79

2010-11-24 16:30:58 0x12C0 19651 CONNECT Connection released, T70

2010-11-24 16:30:59 0x12C0 19633 CONNECT Connect req. (T71, Node:'', PID:4196)

2010-11-24 16:30:59 0x12C0 52104 AUTOSAVE standby mode on

2010-11-24 16:30:59 0x12C0 19651 CONNECT Connection released, T71

2010-11-24 16:30:59 0x12C0 19633 CONNECT Connect req. (T72, Node:'', PID:4196)

2010-11-24 16:30:59 0x1288 19633 CONNECT Connect req. (T80, Node:'', PID:4196)

2010-11-24 16:30:59 0x1288 19617 VOLUMEIO Single I/O attach, 'F:\sapdb\SDB\sapdata\DISKD0002', UKT:8

2010-11-24 16:30:59 0x1288 19651 CONNECT Connection released, T80

2010-11-24 16:30:59 0x1288 19633 CONNECT Connect req. (T81, Node:'', PID:4196)

2010-11-24 16:30:59 0x1288 19651 CONNECT Connection released, T81

2010-11-24 16:30:59 0x1288 19633 CONNECT Connect req. (T82, Node:'', PID:4196)

2010-11-24 16:30:59 0x1288 19651 CONNECT Connection released, T82

2010-11-24 16:30:59 0x1288 19633 CONNECT Connect req. (T83, Node:'', PID:4196)

2010-11-24 16:30:59 0x1288 19651 CONNECT Connection released, T83

2010-11-24 16:31:00 0x1288 19633 CONNECT Connect req. (T84, Node:'', PID:5108)

2010-11-24 16:31:01 0x1288 19651 CONNECT Connection released, T84

2010-11-24 16:31:01 0x1288 19633 CONNECT Connect req. (T85, Node:'', PID:4196)

2010-11-24 16:31:01 0x1288 19651 CONNECT Connection released, T85

2010-11-24 16:31:01 0x12C0 19651 CONNECT Connection released, T72

2010-11-24 16:31:02 0x12C0 19633 CONNECT Connect req. (T73, Node:'', PID:4196)

2010-11-24 16:31:02 0x12C0 19651 CONNECT Connection released, T73

2010-11-24 16:31:02 0x12C0 19633 CONNECT Connect req. (T74, Node:'', PID:4196)

2010-11-24 16:31:02 0x12C0 19651 CONNECT Connection released, T74

2010-11-24 21:00:03 0x12C0 19633 CONNECT Connect req. (T75, Node:'', PID:2384)

2010-11-24 21:00:03 0x12C0 1 Savepoin Savepoint (SaveData) started by T75

2010-11-24 21:00:03 0xF68 20004 Pager SVP(1) Start Write Data

2010-11-24 21:00:03 0xF68 20005 Pager SVP(1) Stop Data IO, Pages: 2 IO: 2

2010-11-24 21:00:03 0xF68 20006 Pager SVP(2) Wait for last task: 154

2010-11-24 21:00:03 0xF68 20007 Pager SVP(2) Stop Wait for last task, Pages: 0 IO: 0

2010-11-24 21:00:03 0xF68 53070 SAVPOINT B20PREPARE_SVP: 2613

2010-11-24 21:00:03 0xF68 20008 Pager SVP(3) Start Write Data

2010-11-24 21:00:03 0xF68 20009 Pager SVP(3) Stop Data IO, Pages: 2 IO: 2

2010-11-24 21:00:03 0xF68 20010 Pager SVP(3) Start Write Converter

2010-11-24 21:00:03 0xF68 20011 Pager SVP(3) Stop Converter IO, Pages: 11 IO: 11

2010-11-24 21:00:03 0xF68 53071 SAVPOINT B20SVP_COMPLETED: 2613

2010-11-24 21:00:03 0x13F0 19625 IO Async I/O thread started, 'C:\Documents and Settings\All Users\Application Data\sdb\data\SDB\data\DISKD0001

2010-11-24 21:00:03 0xE18 19625 IO Async I/O thread started, 'F:\sapdb\SDB\sapdata\DISKD0002

2010-11-24 21:00:03 0x3C4 19625 IO Async I/O thread started, 'F:\sapdb\backups\Complete_BU\MAX_DEV_CS_COM

2010-11-24 21:00:04 0xF68 52101 SAVE Filetype: file

2010-11-24 21:00:04 0xF68 52024 SAVE 200 pages -> "omplete_BU\MAX_DEV_CS_COM"

2010-11-24 21:00:08 0xF68 52024 SAVE 33600 pages -> "plete_BU\MAX_DEV_CS_COM"

2010-11-24 21:00:13 0xF68 52024 SAVE 61200 pages -> "plete_BU\MAX_DEV_CS_COM"

2010-11-24 21:00:18 0xF68 52024 SAVE 75200 pages -> "plete_BU\MAX_DEV_CS_COM"

2010-11-24 21:00:23 0xF68 52024 SAVE 85200 pages -> "plete_BU\MAX_DEV_CS_COM"

2010-11-24 21:00:28 0xF68 52024 SAVE 100600 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:00:33 0xF68 52024 SAVE 127800 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:00:38 0xF68 52024 SAVE 154400 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:00:43 0xF68 52024 SAVE 184800 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:00:48 0xF68 52024 SAVE 215800 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:00:53 0xF68 52024 SAVE 253000 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:00:58 0xF68 52024 SAVE 289200 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:01:03 0xF68 52024 SAVE 329600 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:01:08 0xF68 52024 SAVE 363800 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:01:13 0xF68 52024 SAVE 394400 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:01:18 0xF68 52024 SAVE 418200 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:01:23 0xF68 52024 SAVE 452200 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:01:28 0xF68 52024 SAVE 492400 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:01:33 0xF68 52024 SAVE 519600 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:01:38 0xF68 52024 SAVE 553000 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:01:43 0xF68 52024 SAVE 581400 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:01:48 0xF68 52024 SAVE 603200 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:01:53 0xF68 52024 SAVE 627400 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:01:58 0xF68 52024 SAVE 654200 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:02:03 0xF68 52024 SAVE 682000 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:02:08 0xF68 52024 SAVE 703400 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:02:13 0xF68 52024 SAVE 722600 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:02:18 0xF68 52024 SAVE 747600 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:02:23 0xF68 52024 SAVE 777600 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:02:28 0xF68 52024 SAVE 796200 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:02:33 0xF68 52024 SAVE 806800 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:02:38 0xF68 52024 SAVE 831200 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:02:43 0xF68 52024 SAVE 867600 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:02:48 0xF68 52024 SAVE 890000 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:02:53 0xF68 52024 SAVE 902400 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:02:58 0xF68 52024 SAVE 922000 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:03:03 0xF68 52024 SAVE 953200 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:03:08 0xF68 52024 SAVE 981400 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:03:13 0xF68 52024 SAVE 990400 pages -> "lete_BU\MAX_DEV_CS_COM"

2010-11-24 21:03:18 0xF68 52024 SAVE 1002000 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:03:23 0xF68 52024 SAVE 1021800 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:03:28 0xF68 52024 SAVE 1048200 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:03:33 0xF68 52024 SAVE 1060200 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:03:38 0xF68 52024 SAVE 1068000 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:03:43 0xF68 52024 SAVE 1084000 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:03:48 0xF68 52024 SAVE 1118600 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:03:53 0xF68 52024 SAVE 1154200 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:03:58 0xF68 52024 SAVE 1195600 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:04:03 0xF68 52024 SAVE 1229800 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:04:08 0xF68 52024 SAVE 1268400 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:04:13 0xF68 52024 SAVE 1298800 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:04:18 0xF68 52024 SAVE 1323800 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:04:23 0xF68 52024 SAVE 1344400 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:04:25 0xF68 52024 SAVE 1357496 pages -> "ete_BU\MAX_DEV_CS_COM"

2010-11-24 21:04:25 0x3C4 19626 IO Async I/O thread stopped, 'F:\sapdb\backups\Complete_BU\MAX_DEV_CS_COM'

2010-11-24 21:04:25 0x13F0 19626 IO Async I/O thread stopped, 'C:\Documents and Settings\All Users\Application Data\sdb\data\SDB\data\DISKD0001'

2010-11-24 21:04:25 0xE18 19626 IO Async I/O thread stopped, 'F:\sapdb\SDB\sapdata\DISKD0002'

2010-11-24 21:04:25 0x12C0 52012 SAVE ready

2010-11-24 21:04:25 0x12C0 19651 CONNECT Connection released, T75

2010-11-25 01:34:42 0x12C0 19633 CONNECT Connect req. (T76, Node:'', PID:4420)

2010-11-25 01:34:42 0x12C0 19651 CONNECT Connection released, T76

2010-11-25 01:34:43 0x12C0 19633 CONNECT Connect req. (T77, Node:'', PID:4420)

2010-11-25 01:34:43 0x1288 19633 CONNECT Connect req. (T86, Node:'', PID:4420)

2010-11-25 01:34:43 0x1288 19651 CONNECT Connection released, T86

2010-11-25 01:34:43 0x1288 19633 CONNECT Connect req. (T87, Node:'', PID:4420)

2010-11-25 01:34:43 0x1288 19651 CONNECT Connection released, T87

2010-11-25 01:34:43 0x1288 19633 CONNECT Connect req. (T88, Node:'', PID:4420)

2010-11-25 01:34:43 0x1288 19651 CONNECT Connection released, T88

2010-11-25 01:34:43 0x1288 19633 CONNECT Connect req. (T79, Node:'', PID:4420)

2010-11-25 01:34:43 0x1288 19651 CONNECT Connection released, T79

2010-11-25 01:34:43 0x1288 19633 CONNECT Connect req. (T80, Node:'', PID:4024)

2010-11-25 01:34:44 0x1288 19651 CONNECT Connection released, T80

2010-11-25 01:34:44 0x1288 19633 CONNECT Connect req. (T81, Node:'', PID:4420)

2010-11-25 01:34:44 0x1288 19651 CONNECT Connection released, T81

2010-11-25 01:34:45 0x12C0 19651 CONNECT Connection released, T77

2010-11-25 01:34:45 0x12C0 19633 CONNECT Connect req. (T78, Node:'', PID:4420)

2010-11-25 01:34:45 0x12C0 19651 CONNECT Connection released, T78

2010-11-25 01:34:45 0x12C0 19633 CONNECT Connect req. (T69, Node:'', PID:4420)

2010-11-25 01:34:45 0x12C0 19651 CONNECT Connection released, T69

-

---

current write position -

---

=========================================== end of write cycle ===================

[Former Member · Accepted solution]

When you logon to your database from Database manager is your database state is green or amber?

I can't see any errors in your last logs.

[Former Member · Accepted solution]

It is green..

[Former Member · Accepted solution]

Fine mean your database is now up.

Do you still have issues while accessing from http://<servername>:port you should get some response. ie http://strap1346.crop.trep.org:1090/

In OAC0 select your repository -> and perform test connection. also check the CS admin status.

[Former Member · Accepted solution]

i get the following error

500 (Internal Server Error)

CreateTab ContentStorage, connect error SQLConnect failed, Specified driver could not be loaded due to system error 193 (MaxDB)., Error Code: 160

[Former Member · Accepted solution]

Was this working before or this is you new configuration? and have you checked below aswell:

tcode - > OAC0 select your repository -> and perform test connection. also check the CS admin status.

[Former Member · Accepted solution]

It was working before...It is not been working for past few days.We reinstalled the MAxdb and content server yes.But still we are getting the error.

[Former Member · Accepted solution]

When you re-installed the maxdb have you restored the database backup? or now you have fresh database and no data in your database.

You have not responded the another query which I have requested you to test.

[Former Member · Accepted solution]

It is from a db backup.

In OACo, all repositories[MaxDb] are in defined state.

But repositories related to file storage are in running state.

[Former Member · Accepted solution]

If you are a SAP customer then I suggest you to open an OSS message for this issue. And make sure you epxlain the error in detail.

[Former Member · Accepted solution]

thx..a message has already been opened.

[Former Member]

Issue resolved

[Former Member]

Can you please provide the solution? so that others can solve the issue if they have same error.

[Former Member]

The solution is found in sap note 301352.

Try running the following command.

The command is in the following format:

Odbcreg MaxDb u2013i u2013p c:\sapdb\programs\pgm

[Former Member]

We also got the same error.. Mot importantly if the DB is created manually  the SAP user must be created using the note (582765 - SAP Content Server cannot address database) and register the driver using the command odbcreg

Thanks.