Lowyat.NET: Latest topics by hata94

can't allocate spaces for object 'Syslogs'

hata94 — Wed, 18 Nov 2009 14:38:44 +0800

Dear all,
I was running a application which is connect to database MSSQL6.5. While i trying to update statement, the error message prompt "Can't allocate space for object 'Syslog' in database 'dbname' because the logsegment is full. If you ran out of space in syslogs, dump the transaction log.....".

I've tried the following steps:-
under Enterprise Manager:
checked tempdb's data space available 150mb,
dbname's data space available 650 MB, log space available 250;
under dbname's option, Select Into / Bulk Copy and Truncate Log on Checkpoint were set to true

In query:
Dump TRANSACTION dbname WITH NO_LOG
go
DBCC CHECKDB (dbname)
go

Both results return no error. In Enterprise Manager, i've remove the backup devices as well as the dumpdevices in the directory then re create the backup device and backup the db again. After that i go back to the application to do the update, but the particular message prompt again...

I've tried googling around but can't get to solve this problem. I wonder is it setting problem? below are my server configuration:-
name minimum maximum config_value run_value
allow updates 0 1 0 0
backup buffer size 1 32 1 1
backup threads 0 32 5 5
database size 2 10000 2 2
default language 0 9999 8 8
fill factor 0 100 0 0
language in cache 3 100 3 3
LE threshold maximum 2 500000 200 200
LE threshold percent 1 100 0 0
locks 5000 2147483647 20000 20000
logwrite sleep (ms) -1 500 0 0
max async IO 1 1024 8 8
max text repl size 0 2147483647 65536 65536
max worker threads 10 1024 255 255
media retention 0 365 0 0
memory 2800 1048576 128844 128844
nested triggers 0 1 1 1
network packet size 512 32767 4096 4096
open databases 5 32767 5000 5000
open objects 100 2147483647 500 500
procedure cache 1 99 30 30
RA worker threads 0 255 3 3
recovery flags 0 1 0 0
recovery interval 1 32767 5 5
remote access 0 1 1 1
remote conn timeout -1 32767 10 10
remote proc trans 0 1 0 0
show advanced options 0 1 0 0
tempdb in ram (MB) 0 2044 150 150
user connections 5 32767 50 50
user options 0 4095 0 0

The MSSQL6.5 is updated until SP 5A, while googling found out SP5A would solve this problem but it still appear. Appreciate alots if anyone could help, if you have any sites or reference for this particular problem, please do let me know.

Thanks alot
Regards

PowerBuilder 6.5

hata94 — Thu, 24 Jan 2008 21:15:31 +0800

Hi there, just wonder is there anyone familiar with Power Builder?Got some question to ask about...

I have encounter a error while retrieving records from a report. All of the processing for the report is done on the database server in stored procedures. The store procedures populate a work table which is used by the front end for data retrieval.

The datawindows which retrieve the data have multiple bands and aggregate functions to achieve the display that is desired. However, when more than approx. 500,000 rows are retrieved, Power Builder runs into memory allocation problems due to the aggregate functions, sorting and grouping in the data window. The error message is 'pb60.exe, insufficient memory'.....

I guess its probably not the RAM problem, in fact my company pc's ram up to 1GB and i believe that a accounting software wont take too much resources on that one. Even i use my company pc to play dota still running ok... =.=

Is there any setting in Power Builder setup environment which addresses memory usage? Anyway i've tried GarbageCollect() and set undocumented "storagepagesize" to "large" and still cannot work up.....someone please help..i've been cracking my head for this few days for asking uncle google about Power Builder tips and still cant make it =.=

[addedon]January 25, 2008, 4:15 pm[/addedon]anyone got any idea on this? or anyone got any power builder references besides the sybase official site? really appreciate for any comment/advise..

IFCA International

hata94 — Wed, 24 Oct 2007 13:05:40 +0800

anyone heard of IFCA International?has anyone working there?pls share ur experience...

Driver installation..

hata94 — Wed, 24 Oct 2007 12:28:57 +0800

My company currently using a HP Designjet 100 plus, when i've installed the driver, the printing properties all suddenly change to chinese character....while installing the driver i'd choose english to proceed the installation but then why it suddenly comes out with chinese character? i heard my colleague said the driver disc their install last time working properly, and nv see this chinese character comes out..anyone got any idea?pls help...kinda blur...

Auto Shut down / Switch on program

hata94 — Tue, 02 Oct 2007 13:02:45 +0800

Hi there,
just wanna know is there any program for pc auto shut down or switch on in particular time setted? or the windows itself has the function to do so?btw im using win xp..thx

Sony DCR - HC20E Pal Digital Camcorder

hata94 — Tue, 25 Sep 2007 13:31:25 +0800

Hi there,
I got a sony camcorder from frens...Asking me help to become the camera man lolz....The problem is im kinda noob in this, thus asking you guys abit favor on how to use this camcorder..
The model is Sony DCR-HC20E, i think i could manage to use it for record/taking snap, but im not really know on how to get those picture/ video that i've took in the cam and put them into the pc..
There's a software called Picture Package which comes together with the cam, and i did give it a try on the particular software.This software actually has some function to choose, like automatic slideshow producer, saving images to cd-r, viewing images/video on pc,automatic video producer and copy the recorderd video on videocd..
i choose the viewing images/video on pc,it comes out a empty dialog box, with button which i can choose the media from either memory device and browse(which choose files from the pc). i click on the memory device button but there's nothing happen....anyway the cam itself got some pictures and videos within so it should be able to view from there on..trying out a whole morning lolz still nothing happens.....Anyone knows how to use it please let me know please..anyway thanks =)

regards,
hata