Recent content by MrStiffler

Hi everbody. I think it is not possible with the MQ Series adaptor to append an output to a Queue. So here is the scenario: I have a simple queue get filled with around 100'000 messages a day. Every Message in the Queue has only one simple record. The only thing to do is to sort all the...

Hi Mercator's I have a queue where once a day a map read on timetrigger , all messages till this time event. MQ Series Queuemanager is defined so, that only a maximum of 10'1000 Messages can be retrieved per read process (LUW). So i the queue will have much more messages then 10000, so a MQ...

We had a lot problems with the second Patch of 6.5 so we reinstall mercator 6.5.1 ! But on different points we had problems by receiving messages from queues (IBM MQ Series) and we could fix some of it by using -REFRESH x ! Choose the x not to low because loosing performance ! Do you have any...

Hi everybody I have the problem that i get this message when running a map on the Merc 6.5 Event Server on Unix Solaris: Failed to connect to the database (Error Code -1005) When testing on my NT client it works fine ! On Unix i only changed the syntax of the connnection string and ad " ' at...

I have a Series of object which i test to be present in a Oracle Table. In the Serie there could be more then one of a object, so there could be 1000 of the same object. Normaly the object is present in the DB, but if there i a new object in the serie, i write a record to the database with that...

On an output card function, i want to update 24 specific filds in an Oracle Database. For each Update i use the dblookup in the function pannel. This means that the card have to make a connection to the database for each dblookup, so this are 24 connection which make the map processing...

The probem is that during reading form the input queue, Mercator stopps reading out messages, and just leave them in the queue ! It is a input queue, so i use only the -QN option ! Wenn doing the same without having the queue in the MQ Cluster, every message will be processed ! Any Ideas ...

Hi Did somebody have some experiences with a Mercator Environment on a Unix Server where we get Messages from a Clustered MQ Series Messaging Syststem ? Without clustering everything works fine ! We use Mercator 6.5 on Unix Solaris 5.3 ! Do you have some ideas ? greets stiffler

Okey thanks, i got this trace message: <26820-351>: Validating the adapter command... <26820-351>: Database type is Oracle <26820-352>: Connecting... <26820-352>: Host string: domain.host.com <26820-352>: UserID : user <26820-352>: Password : **** <26820-352>: Error in: OCIServerAttach...

I want to connect from an merc 6.5 to an Oracle Server on a different machine (both are Unix Soraris). I work without mdq files. So on a simple output card of the map, i have a DBLOOKUP like this : DBLOOKUP("SELECT * FROM mytable", "-DBTYPE ORACLE -CONNECT domain.server.com -USER myusername...

Hi In a TypeTree i have fields that always starts with a different number of 3 digits followed by 2 digits that are always be the same: So it looks like this 444_j04 333_j05 567_j04 To recognize the fiels (s) i have to set an initiator. But it needs 3 wildcards at the begining. What...

Here are the system requirements and an description how to install connection from a sun unix server : System Requirements In addition to the requirements detailed in the Getting Started book, to install and run the Oracle database adapters: ? You must be running Oracle 7 version 7.3.4 or...

Have you made the changes described in the System Requirements (Chapter 1 in the Oracle Adapter Reference, page 6 & 7 ) I'm just doing the same thing as you ! Do you have some mercator samples to work whit a oracle db? greets

Hi folks There is a problem by getting all *.xml files from a folder as input at a specific time. So, i have an input card 1 (with Source Event) that receive a start file at a specific time. The input card 2 has as input a file folder ../*.xml. On this card there is no source event. What i have...

I have a Queue (MQ Series) where during the day, all messages stay in this Queue. At midnight (00:00) i want a map to read out all messages. For this reason, the map has a Time Event, every day at 00:00. Now when the map starts at midnight, the map just get one message and leafe all the others...