p;ErrorID=1135891)
-Ursprüngliche Nachricht-
Von: news [mailto:[EMAIL PROTECTED] Im Auftrag von Marcin P
Gesendet: Dienstag, 8. November 2005 09:53
An: maxdb@lists.mysql.com
Betreff: AK System error: VAK724 1 with 7.5.0.30
Hello,
After migration from 7.3 to 7.5.0.30 I keep receiving
&q
Hello,
After migration from 7.3 to 7.5.0.30 I keep receiving
"General error;-9404 POS(1) System error: AK System error: VAK724 1"
after executing the query below, which is very similar to
http://archives.neohapsis.com/archives/dev/sapdb/2005-q1/0830.html
I did a quick search and it seems to me tha
Hello,
Yes, the MSDN docs aren't clear here - it's true.
I can't see anything wrong with parameters, however,
there IS something wrong with your command text.
You should change it to the:
.Commandtext = "CALL WWIND.BESTELLUNGNEU(?,?)"
One question mark should be provided for every parametr of sp.
I can't say about the internal storage
and the space occupied by the data.
However, during my tests I noticed that
ODBC Driver seems to pull the varchar(size)
column values as they were char(size).
It looks like there is no optimization for receiving and sending data.
Can anyone confirm?
Or is it
Hello Thomas,
Ooopss, I was almost sure
that it was "the history thing" ;-)
Anyway- thank you very much for your interest
and fixing the bug.
Best regards,
Marcin Pytel
--
Uzytkownik "Anhaus, Thomas" <[EMAIL PROTECTED]> napisal w wiadomosci
news:[EMAIL PROTECTED]
Marcin Pytel wrote :
>Hello!
Hello!
I think I have a kind of deja vu.
Coming back to the early version of SAP DB
(I think something about 7.3.0.18 or 7.3.0.20)
I remember reporting the bug about using sequences
in stored procedures.
Luckily this isn't very serious and the workaround isn't too much
complicated :-)
The problem i
Hello Holger,
Thank you very much for your interest and confirmation.
I will keep an eye on the wbts.
Best regards,
Marcin Pytel
--
Uzytkownik "Becker, Holger" <[EMAIL PROTECTED]> napisal w wiadomosci
news:[EMAIL PROTECTED]
Marcin P wrote:
> Hello,
> I think I'v
Hello,
I think I've found a bug with ROWNO in WHERE clause -
it doesn't work as expected.
Here is a sample script:
CREATE TABLE "TALD_ADMIN"."TBLTEST_ASSETS"
(
"REC_ID" Fixed (15,0) NOT NULL,
"INVENTORY_NO" Varchar (50) ASCII,
"IMPORT_OP_ID" Integer,
PRIMARY KEY ("REC_ID")
)
//
CREATE TABLE "TALD_
Have you tried:
Dsn=Mydsn;uid=QUERY1;serverdb=DEMODB;servernode=Mynode;pwd=MYPASS ??
It helps sometimes ;-)
Marcin
--
Uzytkownik "Dima Semenskyy - Home Office" <[EMAIL PROTECTED]>
napisal w wiadomosci
news:[EMAIL PROTECTED]
> Hi!
>
> I'm trying to connect to MaxDB using ODBC, by using DSN and
Hello,
I think I've found a small bug in Odbc driver
included in maxdb-odbc-setup-7_5_00_26.exe.
Environment:
MS .NET Framework 1.1, Visual Studio 2003,
DB Server - SAP DB 7.3.0.48
OS: Windows XP Professional SP2.
Symptoms:
Creating OdbcParameter as Output Parameter
with OdbcType.Int returns erro
reboot the machine (this is a production
server),
and maybe this will help?
Best regards,
Marcin Pytel
--
U¿ytkownik "Marcin P" <[EMAIL PROTECTED]> napisa³ w wiadomo¶ci
news:[EMAIL PROTECTED]
> Hello Thomas,
> Excuse me not attaching this info in the initial post.
>
:[EMAIL PROTECTED]
Hi Marcin
> -Original Message-
> From: news [mailto:[EMAIL PROTECTED] On Behalf Of Marcin P
> Sent: Montag, 23. Mai 2005 09:27
> To: maxdb@lists.mysql.com
> Subject: Re: ODBC driver CreateResource problem
>
> Hello Thomas,
> Excuse me not attaching
Hello Thomas,
Excuse me not attaching this info in the initial post.
Here's what I've got:
SAP DB ODBC Driver comes from installation package odbc74.3.27-setup.exe
MDAC 2.8 is used.
All of this in installed on Windows 2000 Server.
I connect to my SAP DB 7.3.0.40 database running on Linux Red Hat 7.
Hello,
I've written a rather simple Windows Service which
updates Data from Active Directory in my database.
It works very fine, however, after 10-12 days it stops
with the error described in the log event below.
Has anyone any clue?
I'd be very grateful for your help.
Marcin Pytel
The system has
Take a look into the Docs and search for MAPCHAR.
I use it for sorting with Polish (a,e,c etc.)special letters and everything
works fine. However, you must remeber to add MAPCHAR clause
in every query you do.
Good luck,
Marcin P.
--
Uzytkownik "Michael P." <[EMAIL PROTECTE
Hello Elke,
IMHO simplicity is our friend :-)
Until now I haven't make any use of it.
Anyway, if this could to cause any trouble
to any of happy users of SAP DB/ MaxDB
maybe it would be good idea to publish
somewhere (i.e. docs?) the definition of the views
which will return the data as the removed
Hello,
For those of you who are still using some older versions of MaxDB / SAP DB
(as I'm), here is very important notice about exploit code.
http://www.sans.org/newsletters/risk/display.php?v=4&i=16.php#other1
It's alway better to know and to apply workaround.
Best regards,
Marcin Pytel
--
RTFM ;-) - e.g. SqlStudio.chm
Basic Information ->
The (SAP DB / MaxDB) Database System ->
Security Concepts
and
Basic Information -> Reference Manual -> Authorization
HTH
marcin
U?ytkownik "Íõ Ðñ" <[EMAIL PROTECTED]> napisa? w wiadomo?ci
news:[EMAIL PROTECTED]
>I want to know the security m
Hmmm,
I did a trick from
http://archives.neohapsis.com/archives/dev/sapdb/2004-q2/0152.html
and know, when I try to put my db online the error is:
migration failed with error -8
Has anyone any idea?
Marcin
U¿ytkownik "Marcin P" <[EMAIL PROTECTED]> napisa³ w wiadomo¶ci
news:
Hello once again,
I have (almost) succeded with moving data from 7.3 to 7.6 instance.
However, in the end of the recovery process I keep getting the error:
-24988 sqlerror [db_restartinfo]; -9209, System error: KB log error.
I took a look into the db log and that is what I found there:
2005-03-31
Hello Uilton,
I'm not sure what kind of info are you exactly
looking for, but AFAIK:
Max DB has no special, built-in, tool for OLAP
in sense of data mining and all subjects related
to it. There is quite nice designer in
SQL Studio (a SQL tool designed to work with
MaxDB) which may be used for build
Hi,
As I wanted to check the newest versions of
MaxDB, I would like to copy my data from our
server running SAP DB 7.3.040 to my new installation
(it will be 7.5 or 7.6 - I haven't yet decided).
I know about executing util_execute migrate just before the
backup, however I don't
want any changes to
IMHO writing a simple Stored Procedure should help
You should of course give the user a privilege to execute this SP
with GRANT statement.
Marcin
Uzytkownik "Jens Stier" <[EMAIL PROTECTED]> napisal w wiadomosci
news:[EMAIL PROTECTED]
> Hi,
>
> i want to find which users are connected. As DBA i
I can only add here, that one of my test instances
is working on Pentium III 600 MHz with only
192 MB RAM.
And for small data size (~200MB) everything is OK.
Also installing it on laptop with PII 450 and 192 MB was
no problem and worked OK.
Greetings,
Marcin
U¿ytkownik "Hermann Himmelbauer" <[EMA
e able to take advantage of the
> new .net syntax like datasets etc...
>
> I am assuming you actually tried a compiled-code connection,
> perhaps the "server explorer" piece works but an actual
> compile via the framework might yield the same error I listed above.
>
>
Yes, it's true that Ado relies on OLEDB.
There is a possibility to use Microsoft Oledb Bridge
for ODBC - I didn't use it as long as Odbc works fine on my site.
In your example, it seems to me that you're trying to connect
to SAP DB/MaxDB with Oledb Driver for MS SQL.
Try building ConnectionString
Now it's clear :-)
The easiest way is to go to Database Manager -> Recovery -> Index
and then select the indices that may be corrupted and
press "Recreate".
Hope this helps,
Marcin
Uzytkownik <[EMAIL PROTECTED]> napisal w wiadomosci
news:[EMAIL PROTECTED]
> I said that because my system crash and
Use C-like comments, eg.
/* this is my comment inside DP_PROC */
It works perfectly on my side,
Best regards,
Marcin
Uzytkownik "maxdb" <[EMAIL PROTECTED]> napisal w wiadomosci
news:[EMAIL PROTECTED]
> How to save my comments inner my db functions or procedures?
>
>
> --
> MaxDB Discussion Maili
Thanks for this patch.
I really appreciate the decision to publish this valuable changes
at the end of SAP DB support era.
It was really great work during two last years
- my congratulations and many thanks to all people from SAP DB/MaxDB Team.
I hope that won't change during Max DB times :-)
Best
th ASP.NET.... you have been warned.
>
> Stephen Gutknecht
>
>
>
> On Fri, 26 Mar 2004 09:26 , 'Marcin P' <[EMAIL PROTECTED]> sent:
>
> >Yes - but only with
> >standard ODBC driver (use .NET provider
> >for ODBC drivers).
> >It works perfect with
Yes - but only with
standard ODBC driver (use .NET provider
for ODBC drivers).
It works perfect with 7.3.0.46.
(I haven't yet tested 7.4 nor 7.5).
Lool at my latest post concerning Mono
and Daniel's answer -
http://www.bytefx.com/Products.aspx
It seems the .NET Provider for MaxDB/SAP DB is on
the w
Daniel,
Thanks a lot!
I will keep an eye on it and wait until they add
a support for my favourite DB :))
Best regards,
Marcin Pytel
Uzytkownik "Daniel Dittmar" <[EMAIL PROTECTED]> napisal w wiadomosci
news:[EMAIL PROTECTED]
> Marcin P wrote:
> > I wonder I anyone have
t; <[EMAIL PROTECTED]>
napisal w wiadomosci
news:[EMAIL PROTECTED]
Hi Marcin
> -Original Message-
> From: news [mailto:[EMAIL PROTECTED] Behalf Of Marcin P
> Sent: Montag, 22. März 2004 08:36
> To: [EMAIL PROTECTED]
> Subject: .NET and ODBC Drivers - error -4008
>
>
>
Hi!
I just wanted to drop you a line that I've noticed strange behaviour
of ODBC drivers for SAP DB 7.4/MaxDB 7.5.
I installed the newest driver from ftp.sap.com on my Windows 2003 server
and tried to use it in Visual Studio .NET to make a test connection to my
development
server (SAP DB 7.3.0.46 o
Hello!
I wonder I anyone have managed to
connect to SAP DB from Mono framework??
Thanks in advance,
Marcin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
That's what the tool called Loader is for.
Take a look into the docs and the archives of
this list for details.
Good luck
Marcin
U¿ytkownik "Pius, Edward" <[EMAIL PROTECTED]> napisa³ w wiadomo¶ci
news:[EMAIL PROTECTED]
> Hello,
>
> I am trying to load a huge amount of data into a table (a
Hello,
I just wanted to completely support
Edson's opinions and together with him
ask you (I mean SAP DB/MAX DB team)
for a little more time for testing and preparing
migration towards 7.5.
So far I use this great Database in a few applications,
two of them are rather critical (business-sensitive,
I would use Stored Procedure with
loop - and inside of it i'd built dynamic
SQL Statement (look in archives for examples -
it was a few of them).
Marcin
U¿ytkownik "Dusan Kolesar" <[EMAIL PROTECTED]> napisa³ w wiadomo¶ci
news:[EMAIL PROTECTED]
> Hello,
>
> I want to insert row into more then one
Thanks Daniel,
I'm beginning the download,
Marcin
Uzytkownik "Dittmar, Daniel" <[EMAIL PROTECTED]> napisal w wiadomosci
news:[EMAIL PROTECTED]
> > Problem is that
> > ftp://ftp.sap.com/pub/sapdb/
> > doesn't allow to log as anynomous user.
>
> The FTP server is now open for anonymous users.
>
> D
Hi Elke & Thomas,
Thank you very much for your fast clarification.
Now I know a little more ;-))
Thanks again,
Marcin
"Anhaus, Thomas" <[EMAIL PROTECTED]> napisal w wiadomosci
news:[EMAIL PROTECTED]
> Marcin wrote :
>
> >Hello,
> >I just would like to let you know, that I've noticed
> >SAP DB is
Hello,
I just would like to let you know, that I've noticed
SAP DB is acting really strange when non-existing function
is used in SELECT clause.
For example:
SELECT SILLY_NAME_OF_FUNCTION(MY_COLUMN) FROM MY_TABLE,
returns all rows from MY_TABLE for column MY_COLUMN.
IMHO some error that the given f
Problem is that
ftp://ftp.sap.com/pub/sapdb/
doesn't allow to log as anynomous user.
Have you changed the policy?
Could you give us some id and password?
Best regards,
Marcin
Uzytkownik "Schmoger, Daniel" <[EMAIL PROTECTED]> napisal w wiadomosci
news:[EMAIL PROTECTED]
hi,
there is a bug in this d
Looks like DNS issue, doesn't it?
Search in archives how to solve the problem with long
connecting times...
Regards,
Marcin
U¿ytkownik "Joao" <[EMAIL PROTECTED]> napisa³ w wiadomo¶ci
news:[EMAIL PROTECTED]
> Hello,
>
> I Have a big problem
>
> I Have a AIX system in IBM Risc System 6000...
> 450 M
Hi Axel,
> Pitfall: Backups are platform-dependent. You can not restore a backup from
a UNIX or LINUX
> database instance on a Windows host.
I can't agree.
I use SAP DB 7.3.0.40, do my backups on my Linux RH,
and then recreate the instance on my notebook with Windows XP.
Works without any problem
Even if it is 10 cents it's still commercial :(
Just my 0.02$.
And BTW:
In doc You've enumerated:
Sequences,
Foreign Keys,
Table Definitions,
Table Data.
Haven't you missed something? (e.g. constraints, privileges)
Marcin
...
> you can hardly call 10 bucks a commercial application. it will cover
Hi Stephen.
Just wanted to drop you a line -
when it comes to SAP DB (not MaxDB),
Linux RH 7.2, kernel 2.4.20-20
When it comes to machines -
for two years my production server
was Compaq 2xPIII 800 MHz,
512 MB of RAM, RAID.
Recently I have upgraded to:
2 x PentiumXeon 2GHz,
RAM - 2GB,
RAID etc.
Wo
IMHO it would be much better to
Call objConn.Execute "INSERT INTO IMPOSTAZIONI(NOME,VALORE)
VALUES('VAR-NAME1','1.2.3')
and the best would be to use command object with parametrized query (or
Stored Procedure).
Why would you get all the records from this table when you only
want to insert one ??!
Hi all!
As the Christmas time is coming I would like to
wish You all the best for Christmas and many gifts from Santa Claus -
have a wonderful time during these holidays.
I'll be out of the office for the next several days, so I already would
like to thank all of you for your clues, hints or just o
> Don't let Richard Stallman hear you when you say that GPL software is not
free ;-)
Heh - great tip, I'll whisper ;-)
> As our focus shifted to 7.4 and now to 7.5, it is not unreasonable that
stable releases get fewer updates.
..
> We won't be able to support 7.3 and 7.4 after March 2004 outside
Hi Juergen!
I understand You dissapointment - and share it to
some degree. What is really strange is the statement
(about 6-7 months ago it was still in FAQ on sapdb.org)
that all the future versions of this software will be free.
Are they now? I don't think so.
But - I do understand it - it must h
TECTED]> napisal w wiadomosci
news:[EMAIL PROTECTED]
> Hi Marcin,
>
> Marcin P wrote:
> >
> > For several days I've got an opportunity to make some first tests
> > with Microsoft Longhorn OS (Alfa).
> > Today I made a first try with SAP DB.
> > The
I had the same with my Linux Red Hat 7 instance.
As far as I remember the reason was the luck of
free semapthores and after my colleague has increased the
number of semaphores everything went perfectly.
As I'm not Linux expert I cannot tell you what command
should you use in order to increase the n
I'm afraid the problems you spotted are due
to rather ineficcient algorithm used by SAP DB
to make joins.
It copies a lot of data to temporary spaces and
this is the reason you get the error.
I observed the same behaviour when playing
with huge sets of data and managed to speed it up a lot.
My very
Hi Markus,
Of course you're right - the reason I gave it a try
is only fun and curiosity :-)
Unfortunately there isn't anything interesting in the klndiag
and klndiag.err.
I only thought that someone could have spotted the error
I mentioned somewhere before and it could give me a clue.
But the ca
Hi!
For several days I've got an opportunity to make some first tests
with Microsoft Longhorn OS (Alfa).
Today I made a first try with SAP DB.
The server (7.3.0.40) was installed succesfully,
so was the DBM GUI Manager.
However, when I try to create a new database I keep
receiving the following er
Oooppsss!
I hurried to much, forgive me that.
The answer is:
ftp://rpmfind.net/linux/redhat/9/en/os/i386/RedHat/RPMS/compat-libstdc++-7.3
-2.96.118.i386.rpm
Let's continue the installation... ;-)
Marcin
U¿ytkownik "Marcin P" <[EMAIL PROTECTED]> napisa³ w wiadomo¶ci
news:[
Hi!
I tried to install the latest version of MaxDB (7.5.0.5)
just for tests on my Linux (Red Hat 9.1) machine.
Unfortunately, during the installation a fatal error occurs:
"SYS: /opt/sdb/programs/bin/dbmcli -R /opt/sdb/7500
inst_reg -k /opt/sdb/7500: /opt/sdb/programs/bin/dbmcli:
error while loadi
news:[EMAIL PROTECTED]
> Marcin P wrote:
>
> > Hi Sven.
> > I experienced similar and more basic problems with joins
> > what make them unuseful.
> > My main trouble occurs when I join data from a view with
> > GROUP BY statement with data from basic tables.
> >
Hi Sven.
I experienced similar and more basic problems with joins
what make them unuseful.
My main trouble occurs when I join data from a view with
GROUP BY statement with data from basic tables.
Then sapdb goes completely crazy and even does not pay
any attention to my final where clause.
To give
Yes, of course.
If goes something like that:
SELECT O.REC_ID,O.REC_DELETED,O.OWNER_ID, O.TEOID_PREPARATION,
O.TEOID_REALIZATION, O.EST_CLOSURE_DATE,
O.OFFER_STATUS,O.OFFER_TYPE,O.CUSTOMER_NAME,O.CUSTOMER_CITY,O.VALID_DATE,O.S
ENT_DATE,O.SUBJECT, O.OFFER_VALUE, CHAR(DATE(O.CREATE_DT)) || ' ' ||
Hi!
Some days ago I have written simple VB6 application
which connects to SAP DB with ADO engine.
SAP DB is 7.3.0.40, on Linux RH.
And everything works fine, except the fact, that
one of my users (running Windows XP) is very oftem getting the error which
says:
-710 Missing select PARSID.
I've taken
Hi!
I have spotted a strange behaviour of SAP DB (7.3.0.40 on Windows XP)
I have created some tables, then put indexes on them (with
multiple columns and single columns).
And then, I tried to add another table (let's say B) which references the
column
in one of the tables created earlier (let's say
Hi Daniel
I always read your posts with big interest and
almost everytime I share your opinions or point of
views.
However, in this specific case I cannot.
The reason is that I made some test with measuring
the times for the amount of time that is needed to
transmit data from a server to the client
Hi Holger!
Once again - thank you
very much for your interest in
resolving all the bugs I bring to light ;-)
Best regards,
Marcin
Uzytkownik "Becker, Holger" <[EMAIL PROTECTED]> napisal w wiadomosci
news:[EMAIL PROTECTED]
> Marcin P wrote:
>
> > I try to deal with joi
Hello!
I try to deal with joins (based on joins) and have found a bug
which is putting my db instance to offline state.
There is a kernel err file in attachment
The way it goes
Tables definition
CREATE TABLE "TALD_ADMIN"."TBL_REPOSITORY_DESC"
(
"FILE_ID" Fixed (15,0) DEFAULT SERIAL (1),
UNIQUE(FIL
65 matches
Mail list logo
