Search results

Use COM HANDLE to import from excel file Stil the easiest way will be to import as csv file Arshad

Hi All , Can anyone help me in telling me the steps to reset my password for progresstalk.com . I had a ID " taqvia " which is not working anymore. need to reset the password for the same. Please let me know the steps to do so. Forum Administrators please unlock my id. Arshaf

Hi Admins, my Id 'taqvia' which I used to login is not working alternatively i had to create a new id taqvia1 to access the site. can you please unlock my orignal id "taqvia" so that I can use the same. Arshad

Hi, Can someone please provide me with valid license keys for MFGpro demo Db. Arshad

Well I encountered a similar issue month back . In my case it was a live database(small one).The solaris box came down and as a result all the DB's running on the box came down. when the box was up all the database came up normally except one with the same error and no conclusive reason was...

It worked and brought the file size what was expected. Thanks Arshad

Version progress 9.1e04(outdated version :) ) yeah i do understand that we should build it from scratch but there are some issues in that and so thought of deleting the entries not required but to my surprise deleting entries has increased the size of pl even though entries were successfully...

Hi, I am bit confused why the size of .pl increases when deleting a entry from pl. I had removed certain entries from pl and expected a decrease in size of pl but on the other hand it increases any idea why? #!/bin/ksh #read entry from txt file which needs to be removed from pl cat...

If your are able to connect to the database pro <dbname> or mpro <dbname> you can chnage the _user account (including password) with the help of below 4gl. DEFINE VARIABLE cNewPassword AS CHARACTER NO-UNDO. DEFINE TEMP-TABLE tempUser NO-UNDO LIKE _User. FIND FIRST _User WHERE _User._UserId =...

2gb file limit for extents depends wether enablelargefiles is on or not. you can just check for it by looking into the log files "Large database file access enabled for db" . while doing a binary dump it should also write to multiple bd's. Also note that if dumping data to a file through 4gl...

Hi, Is the below statement still valid " Progress procedure editor cannot run code if it has more than about 230 open file descriptors. This means if we connect to a number of databases with a total of more than 230 extents, then the procedure editor will not work. This is the main...

Was there any huge transaction active when the shutdown was initiated which might have resulted in rollback causing the delay. Arshad

If I am not wrong Semaphore changes in /etc/system will also require a reboot of box...

prorest <dbname> <backup path>. also have the correct st file present in the direcotry so that files are created as per you locations. or if restoring to a different directory structure use prostrct repair st file. just a quich question have you gone through the Progress Admin guide which...

How did you configure the appserver? through progress explorer or modifying the ubroker.properties file manually. check for the nameserver with which the appserver is getting registered with. check that the particular nameserver is running or not by running the command nsman <nameserver name> -q...

Vageesh, have you tried using solaris command "truss" . This is a very useful command and will give you an idea where/for what/which process is waiting. You need to just pass the the process id of the users affected and output it to some text file for analysis. truss -p <pid> >/tmp/debug.txt...

Who suggested you to switch off the AI? You have missed data from the time you turned off your AI. You could have simply moved all the filled extents to a different location by copying it and marking the extent as empty. You need to stop the DB to start the AI again Thing that you never wanted...

Message indicates that the last progress backup was not successful. Do you take the online backup through progress commands or by any other way. Can you try taking a incremental backup on the restored copy and allow it to complete and then run prostrct repair and see if the error pops up...

Are you trying to start the server after restoring it from backup. It appears that you have taken a operating system level backup of an online database that is one of the reason for such errors. If this is the case then take a progress online backupp and restore it and then restart the server...

Can you please let us know in bit detail about the issue. Is this coming during report generation where you are trying to write the output to same file in multiple threads .... Please be more specific so that we can try to provide a solution Arshad