Questions tagged [sap]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
611 views

SQL query using MAX with multiple table joins

I have a working SQL script to show results that join multiple tables. However, I want to limit the results of the join to show only one record per a given "Chart Number" value in one of ...
jengashare's user avatar
0 votes
1 answer
87 views

Oracle client 12c , if i can't find uninstallation file, can i install 19c client on same server?

I have a server that has oracle 12 client installed but now have an application that references the same server that needs oracle client 19c installed in order to work with the service. I cannot seem ...
OluT's user avatar
  • 1
0 votes
1 answer
5k views

What is the max network latency between synchronous-commit AlwaysOn Availability Groups [closed]

Is there a maximum supported network latency (ms) between two synchronous AlwaysOn replica? I need to give this information to network administrators for configuring the link between the two nodes of ...
Gio's user avatar
  • 107
0 votes
1 answer
453 views

How many databases does a sybase instance have?

I'm a newbie to sybase and could not find the clear answers on Sybase tutorials/docs How many databases can one Sybase instance have? Oracle has one instance which corresponds to only one database, ...
user5844653's user avatar
0 votes
2 answers
328 views

SQL server DAC connection to mssqlsystemresource database

I have a problem while connecting to the mssqlsystemresource database. When I try to connect with DAC connection (without restarting SQL server with -m option) it works, but I can't use the ...
ARAZI's user avatar
  • 1
0 votes
0 answers
533 views

SQL Server database in Recovery mode, how to troubleshoot?

I have a SAP instance running with a 'SQL Server' database that just recently got into recovery mode without a clear reason (no backup or restore was executed). We noticed that the storage for logs (...
comebackhere's user avatar
0 votes
1 answer
24 views

Add a years field to a date field?

I have the below fields and would like to add the contract_term field to the date field: Contract_Term: Years Date: YYYY/MM/DD For example: 3(contract_term) + 2019/01/01(date) = 2022/01/01 What ...
Singh's user avatar
  • 5
0 votes
0 answers
159 views

Trigger to insert new row into second table causes "Connection is busy with results for another command"

I have created this trigger to insert new row into table @AL_ORDR_TRACKER after new row is inserted in table ORDR. CREATE TRIGGER dbo.trgAfterInsertORDR ON dbo.ORDR AFTER INSERT AS BEGIN INSERT INTO ...
W.M.'s user avatar
  • 167
2 votes
0 answers
287 views

Extracting Data from SAP to SQL Server

I am using SSIS packages to extract data from SAP database tables into SQL Server tables. I am using OLEDB source/destination connections to achieve this. The problem now is that a table in SAP has 5 ...
Rahul's user avatar
  • 131
1 vote
1 answer
2k views

Turn off listener logging in oracle 12c release 2

I am trying to turn off listener logging in oracle 12c R2 (SAP on oracle), but I am getting a TNS-12508 error. I have verified that the listener.ora is owned by the oracle user and I am performing the ...
pradyu's user avatar
  • 13
1 vote
1 answer
522 views

SAP BO Freehand SQL date formatting (Oracle db)

My original query worked perfectly via SQL Developer: select * from [table] where DT_CURRENT_DT = '15-OCT-18' However when ran via freehand SQL in SAP BO I got no results. After running the query ...
marcin2x4's user avatar
  • 147
0 votes
1 answer
604 views

What is a online atomic mode backup

I am reading the SAP guide administrator of BO, and I am a little confused about some term they use regardless how to perform online or hot backups. Using the same words For hot backups, use the ...
federico's user avatar
0 votes
1 answer
26 views

How to display all entries that have had a box ticked since a particlar date [closed]

Good afternoon, I would be very grateful is someone would be able to offer some assistance to a query I have regarding some SQL I'm needing to implement. In our database we have a range of customers ...
Chris's user avatar
  • 1
1 vote
1 answer
623 views

ip address record in sybase ASE auditing database? [closed]

everone. I installed the sybsecurity database for auditing in sybase ase 15.5. The installation is OK. I configured the audit commands, for example, for auditing the sa user, and other users of the ...
Luis Antonio Mantilla's user avatar
0 votes
1 answer
1k views

Change left outer join on SAP Universe Design Tools

I need to create a report with SAP Universe Design Tool but when I try to construct a LEFT JOIN between tables, SAP automatically create a LEFT OUTER JOIN when it executes the query in Web Rich Client....
Thomaz Lima's user avatar
0 votes
1 answer
901 views

How do you extract discount data from SAP?

I'm not a SAP developer. We already have a big SSIS package that pulls data from the SQL Server instance that our SAP installation uses and I need to add discount data to it. I've usually had pretty ...
nateirvin's user avatar
  • 760
1 vote
1 answer
282 views

Performance difference between single large Application instance vs multiple small Application Instance in Netweaver [closed]

Can anyone please comment on the performance impact of having a single large application server instance vs multiple small application server instance in SAP Netweaver on a single machine.
a curious engineer's user avatar
0 votes
1 answer
1k views

SQL Anywhere 12 - exporting data to Excel

Do I need to install MS Office Excel on machine where is SQL Anywhere 12 server for below code to work? Or SA 12 or Windows have MS Excel Driver builtin? SELECT * FROM SalesOrders; OUTPUT USING '...
BlueMark's user avatar
  • 247
1 vote
0 answers
67 views

MaxDB - Strange behaviour when selecting from a CLOB-Row

I am using "sqlcli" for Linux to write the output of the following query into a file: select clob_field from table (...) in SAPGui (original user input) the contents are displayed as: First line ...
Alex's user avatar
  • 11
0 votes
1 answer
201 views

MobiLink: How to add a new table to synchronisation using Sybase Central and mlagent

How to add a new table to a synchronisation using mlagent configured from Sybase Central. This might be related to this or this question. When doing a change on remote database as described on ...
frlan's user avatar
  • 495
2 votes
1 answer
229 views

MobiLink: How to propagade schema change for a synch profile to remote databases

Once an application is online with a synchronisation profile it might happen, that the profile needs to be changed. E.g. a new index is introduced, columns are added etc. Having the synchronisation ...
frlan's user avatar
  • 495
1 vote
0 answers
37 views

MobiLink: What is the correct approach of presetting values inside database for remote user

When creating a remote database from inside Sybase Central I'm looking for a way to preset some values based on e.g. subscription user. Application is using some kind of configuration table storing ...
frlan's user avatar
  • 495
1 vote
0 answers
82 views

MobiLink: How to export database users to remote database created via Sybase Central

How to configure a Sybase Central MobiLink project in the way, it's also exporting the database users of consolidated database to a remote database? In default it appears to only create dba with ...
frlan's user avatar
  • 495
0 votes
1 answer
66 views

SQLAnywhere: Mobilink upload_fetch_column_conflict​ seems not to be executed

With Sybase Central I've configured a MobiLink test object, where I'm trying to detect a unique constrain violation before uploading. Unfortunately it appears upload_fetch_column_conflict​ seems to ...
frlan's user avatar
  • 495
0 votes
1 answer
2k views

adding fields to 2LIS_12_VCITM datasource in ECC

From what I have read the datasource 2LIS_12_VCITM is built off of the ECC tables LIKP, LIPS, VBUK, and VBUP. I would like to add a couple of fields that are in the LIPS table to this datasource and ...
Jared's user avatar
  • 101
7 votes
1 answer
341 views

What is "SAP on Oracle"

OK, total newb question. What is "SAP on Oracle", exactly. This link is talking about how SAP can run on Oracle (I think). I'm not understanding how this is working. My understanding: SAP is a ...
Richard's user avatar
  • 6,393