SAP

481

Solutions

746

Contributors

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Share tech news, updates, or what's on your mind.

Sign up to Post

Samsung DS5014S Landline phone

I have a Samsung OfficeServ DS-5014S with the message light flashing, even though there are no messages pending  does anyone have any ideas how to reset
0
NFR key for Veeam Backup for Microsoft Office 365
LVL 1
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

sap Crystal server 2016, how to run and check, how to connect to Oracle, how to call the reports which is published in crs server using visual studio
0
How can I get an sap fico demo cd's or download for training?
0
I have created a desktop application and designed some reports using sap crystal report. First to design report I used database from sql server management studio and put all the field on report. But I have to deploy it client side with localDB after connecting my application with local db I am able to access database on my forms but cant getting data on report. I fetched data in datatable then I am setting datatable as datasource for report but I am getting error."Failed to open the connection Details: Database Vendor Code:4060"

Please provide me correct answer as soon as possible.
Error.PNG
0
Hi

Is there any issue if we setup 'abort tran on log full' for primary database? Does sybase try to kill repagent process in case replication marker is blocking the transaction? Kindly advise.

thanks
Chan
0
I am trying to use "Suppress If Duplicated" on the cross tab's non summarized fields, but it is not working.

Attached is the screen shot for reference.
DuplicateValues.jpg
0
Can you please suggest me on can grow functionality w.r.t cross tab. For example, if the data in one cell is large, then it gets trimmed off instead of wrapping it and enlarging of cell.
Even while exporting cross tab to excel it's not the exactly what was designed in the crystal report. Any solution to achieve this?
While exporting to excel, I select Following steps to export crystal report cross tab to excel:
  • Export Report
  • Microsoft-Excel (97-2003)
  • In Excel Format Option I select "Show Gridlines" field
PurchasingExportAnalysisTabReport_34.xls
0
Hi Experts,
How to check the status of Sybase database are online or offline.
I know sp_helpdb , But is there any other better command which shows state of database.
Thanks.
0
Hello,

I am working with VS2015 C#. Trying to execute a stored procedure from a Sybase db.

It seems to be not receiving the parameters I am trying to send it. I attached the code I'm using with the error msg that I'm receiving.

I'm using this connection string:
Data Source={Adaptive Server Enterprise};server=ppw.amgreetings.com; db=db_cis00;uid=cis;pwd=hotstam;

I am able to receive data back from this db by using embedded sql, but the sp is having issues.

Do you guys see anything I could try differently?

Thanks,
David
DevError1.png
0
Hi Expert,
We are not sure what is the use of SID_AUDIT database, but i understood we will created this as part of post configuration
Can you please tell us what is the use of CMS and Audit database.
Some times database  fills up and we need to add 20gb of space.
Can you tell us how can we analyse this situation.
0
Free Tool: Path Explorer
LVL 10
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Hello,

I am trying to achieve the conditional highlighting of a summarized fields in cross tab.

Basically, I want to compare which has the least value.

Attached image will give better understanding highlight-cross-tab.jpg
How can I find out which summarized field has the least value.
0
We are looking to replace our current SAP systems with a new one.  We were thinking of pointing using a friendly URL to point to the database such as  prodcutionSQLDB.ACME.com  and  productionOracleDB.ACME.com instead of using DB Server name.

This way our application servers just get this FQDN to point to the database.  THis would simplify our DR planning and future migrations.

The question is, does SAP require certificates or something similar where the application servers would not be able to communicate with the DB  (SQL or Oracle).  My understanding is SQL and Oracle use username\pass to authenticate,  or does SAP rely on certificates to communicate with the DB servers?
0
Hi Team,

I need to write a stored procedure to insert and delete a record in a table in sybase . Iam new to Sybase , below is the code I wrote in Oracle stored procedure
-- Oracle version
Create or replace procedure p1 (id number , status out number)
is
begin
insert into t1 values (id);

delete from t2 where empid=id;
commit;
exception
when others then
dbms_output.put_line(SQLCODE || SQLERRM);
rollback;
end;

I need to write the above logic in sybase , any help is really appreciated.  I have tried the below code  , need an help on the exception handling section

create procedure p1 (@id int , out @status int)
as
begin

insert into t1values (@id);
delete from t2 where empid=@id;
set @status=0;
commit;
-- Need help on how to write an exception block which can handle the error
end;
0
Hi

I am accessing in Access, using the sybase ase 15.7 driver, a sybase table that has date/time fieds. However, when accessing that table over an ADODB connection, the values returned are always only a date without time. If I use convert(varchar(8), <datetime field name>, 8) to get the time part, I invariably get a 00:00:00 time, although I KNOW that these fields all have a non-zero time value.

The weirdest is that, if I just open the table in Access (using the SAME ODBC driver to link the table), I see the time in these fields !

What is going on, and how can I get the time portion of these dates ?

Thanks for help.
Bernard
0
Hi,

I have a cross tab in a group header.

I want to sort cross tab according to the third row.

How to achieve this?

For example, the attached image.
LogBook.jpgI want to sort the cross tab as per Part 3
0
I have a server hp-ux with :
[root@csapdev01 ~]# swlist -l bundle|egrep -i "qpkbase|qpkapps|hwenable11i|feature11i"
  FEATURE11i            B.11.31.1209.383a Feature Enablement Patches for HP-UX 11i v3, September 2012
  HWEnable11i           B.11.31.1209.383a Hardware Enablement Patches for HP-UX 11i v3, September 2012
  QPKAPPS               B.11.31.1703.429a Applications Patches for HP-UX 11i v3, March 2017
  QPKBASE               B.11.31.1703.429a Base Quality Pack Bundle for HP-UX 11i v3, March 2017

With SAP installed, i want know the version of SAP kernel for verify there is patches (sap) which must be installed ?

Thks
0
We've got a Successfactors Cloud answer already. After exploring the architecture of SSF we're now capable of discern out that wellknown OData API s are to be had( As part of Integration answer provided with the aid of SSF).

i have multiple queries concerning the Onboarding integration(Odata) functionality.

1) What are all the entity sets to be had for onboarding end to cease capability inside the sap successfactor training  Odata API?

2) Does the the prevailing OData API of SSF helps stop to cease fuctionality of Onboarding? Or can we need to apply SFAPI(cleaning soap UI) for some scenarios?

3) can we have any provision to enhance/enlarge the present OData API in SSF?

Any professionals can resolve my queries.

also we were given to recognise that a standard local cell software is to be had for SSF. can i know on high level whether it supports onboarding capability by using default?
0
This is for my web assessmet SAP S/4 Hana Sales: which steps need to be performed for existing customers to migrate to SAP S/4 HANA? enablement of digital transformation, verification of all data layers, techincal migration, implementation of additional high security measures. In my opinion there are available all the answers, but i`m not sure; without a digital transformation you cannot migrate to S/4HANA, you must verify all the data but I don`t know what all layers means; you  it will be a technical migration, and the experte say there are additional security measures implemented. I really don`t know if my answer is correct because I have multiple choises, but I don`t know the number of correct answers; Thanks a lot! Best regards, Cris!
0
jQuery-UI is one of the 1/3 party libraries which can be blanketed with SAP UI5. however I couldn't locate the way to name it in a given challenge. My paintings around is to include it in a given assignment folder, for example util, and after registering the folder with localResources I load it this way:

jQuery.sap.require("util.jQuery-ui");

Glaringly there is a better manner that's to load the document that is already covered with SAP UI 5https://tekslate.com/sap-ui5-training/! So a way to do that?
0
NFR key for Veeam Agent for Linux
LVL 1
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Hi

Is SAP Replication server 15.7.1 certified on Solaris 11 (sparc T-7)? Can anyone confirm please?

thanks
0
I am trying to start the Sybase Sql Anywhere Personal Database Server 16 and also start/connect/run a specified database file...

Does not work in shortcut (both of these START the DB Server but NOT the db file ???)
"C:\Program Files\SQL Anywhere 16\Bin32\dbeng16.exe" "C:\Data\MyFile.db"

"C:\Program Files\SQL Anywhere 16\Bin32\dbeng16.exe" C:\Data\MyFile.db

http://dcx.sap.com/1200/en/dbadmin/startexe.html
0
Hi All,
We are about to commence a project to start the decommissioning of SAP as we have replaced it with several other pieces of software.
SAP is internally hosted and we intend to archive the data and software as we will not be migrating all of the data to the new systems.  We will also need to keep historic data in order to meet several pieces of legislation.
Below are some of the points I thought that we need to consider, however I have never undertaken such a project before.  From the below, is there anything else I should be thinking about and taking into consideration in terms of the existing SAP infrastructure, the new archiving solution and how we make the move?

Any thoughts are appreciated.

  • Scope of data to be kept in archived SAP
  • Access to the system
- Who has access and what type of access
- Everyone to have read-only access?
- Any requirements for Admin/Developer type access?
- How will Admin/Developer access be granted (fire call)?
  • Decommissioning of old SAP Hardware – How will the hard drives be destroyed or recycled bearing in mind they hold significant private and confidential data.
  • SAP still supported for several years so how do we manage patching to keep it line with PSN requirements.
0
Hello experts,
I'm quite struggling with a date-time problem at Universe (IDT 4.1 SP7)&BO Webinar (14.1.7).

Let's start with customer request:
He needs a Webi report where he can filter by prompt -date and time in separately

For example, if he filters:
Date between 01/01/2016-30/02/2016
Time between 11:00-15:00
He wants to see all data between these dates and time 11:00-15:00

The problem -
In universe -Data Foundation I'm getting from EVENTS table a date-time filed (SQL server) - for example "04:26:47 24/07/2017"
So, on the Data Foundation level (in the EVENTS table) I created 2 "calculation columns"
Date filed - "toDate(@catalog ('RC_Control')."Control.dbo"."EVENTS"."EVENT_TIME_UTC")
Time filed - "toTime(@catalog ('RC_Control')."Control.dbo"."EVENTS"."EVENT_TIME_UTC")

In the Business Layer I created 2 dimentions (date&time)that brings these calculated columns.
Their DataType -Date
On the date filed I'm getting just the date-as I need.
On the Time dimention, on the "Advanced" tab- "Edit display format"-I costumed the format as customer need - "hh:mm"
When I create a query I'm getting the "he:mm" as I need.
Now on BO Webi I created the 2 prompts and here are my problems:
Problem no. 1 : "Time" prompt - I'm getting date only (!!!!). It doesn't recognize the costume I made on the IDT.
I need it to be filtered by "hh:mm" only
Problem no.2 : when I display chosen date filter (by - userResponse("psEnter Value for date (start):") I'm still getting the …
0
Hi,

I am studying the pros and cons of multi site architecture of MS SQL, oracle, MySQL and sybase. I know about MySQL and I am focusing on MS SQL now.

other than AOG, anything else can be good for MS SQL on 2 x data center MS SQL configuration/topology ?
0
#option3
                                update top(10) ud_$REAL_TABLE_NAME
                                set $UD_FIELD_NAME=@id
                                where $$UD_FIELD_NAME is NULL

                                while @@rowcount > 0
                                begin transaction
                                update top(10) ud_$REAL_TABLE_NAME
                                set $UD_FIELD_NAME=@id
                                where $UD_FIELD_NAME is NULL

                                     if @@rowcount > 0
                                       begin
                                            print 'Successfully update @@rowcount no of rows'
                                            commit transaction
                                       end


                                end

                                go

                                set rowcount 0
                                go
0

SAP

481

Solutions

746

Contributors

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Top Experts In
SAP
<
Monthly
>