Questions tagged [sap]
The sap tag has no usage guidance.
27
questions
0
votes
0
answers
37
views
Select, Filter and Sort ist not working with Oracle SQL Developer
I am using SAP ADBC to UPDATE some Oracle database entries.
It's working and the data appearance in the SQL Developer between "normal" and UPDATED entries look same.
But when I use a,
SELECT ...
- 1
0
votes
1
answer
811
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 ...
0
votes
1
answer
100
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 ...
- 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 ...
- 107
0
votes
1
answer
485
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, ...
0
votes
2
answers
391
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 ...
- 1
0
votes
0
answers
547
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 (...
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 ...
- 5
0
votes
0
answers
168
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 ...
- 167
2
votes
0
answers
307
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 ...
- 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 ...
- 13
1
vote
1
answer
541
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 ...
- 147
0
votes
1
answer
625
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 ...
- 17
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 ...
- 1
1
vote
1
answer
642
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 ...
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....
0
votes
1
answer
964
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 ...
- 766
1
vote
1
answer
286
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.
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 '...
- 247
1
vote
0
answers
70
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
...
- 11
0
votes
1
answer
210
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 ...
- 495
2
votes
1
answer
230
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 ...
- 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 ...
- 495
1
vote
0
answers
85
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 ...
- 495
0
votes
1
answer
67
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 ...
- 495
0
votes
1
answer
3k
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 ...
- 101
7
votes
1
answer
343
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 ...
- 1