Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

SAP

480

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

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
Prepare for your VMware VCP6-DCV exam.
LVL 1
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

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
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
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
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
Free Backup Tool for VMware and Hyper-V
LVL 1
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

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
Hi

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

thanks
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
#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
Hi All
i'm looking to get SAP certification in "Finance controlling" module,   any advice?
and is ther any online programm
0
Hi,
Is there any way to disable automatic truncating some of monitoring tables (monSysSQLText, monSysStatement) after SELECT operation? It will make my work a lot easier. I found only a note that ASE assumes that DB user don't want to see it again, which is not true in my case.
I am using Sybase ASE 16.0 & 15.7.
0
I am beginner in SAP and ABAP. I must to do program with BAPI_ACC_DOCUMENT_POST which posted account 602101 to 60210101, but tax rate is 0. I have little proglem. Please help me.
0
If you have data rows like

1.  TypeA.     Control 1.  Answer 1
2.  TypeA.      Control1.  Answer2
3.  TypeA.      Control2.  Answer1
3.   TypeB.    
4.   TypeB.     Control1.  


Where you have three different drop downs
0
Get your Conversational Ransomware Defense e‑book
LVL 1
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Hi,

I have fields License Number, Award Date, Drug Action Classification, International Birth Date in a 2*2 grid and all fields can grow. I have another field 'Name of the Product' which is next column of 2*2 grid but the 2 rows are merged. When I set the property fo the field to 'Can Grow' = true, then this layout breaks and below field is overlapped. I also tried putting fields in different sections, but then the layout of 'Name of the Product' all breaks and I am not able to have a layout as per client requirement. Kindly suggest a work around this problem.

Thanks in advance.

Rahul
0
Hi,
I'd like to update automatically the statistics for single table in SYBASE ASE every 3 days.

If anybody had tried updating automatically the statistics for single table in SYBASE, please share the procedure with me.

Thanks in advance!
0
I have one 12U1 SLES machine in which i want to open an port no 31015 for SAP HANA but unable to.

Netstat -tulpn also not showing LISTEN to this port .

I have also tried it with Yast2 firewall advance option but dont same problem

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      2475/sshd
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      2169/master
tcp        0      0 0.0.0.0:51013           0.0.0.0:*               LISTEN      2341/sapstartsrv
tcp        0      0 0.0.0.0:51014           0.0.0.0:*               LISTEN      2341/sapstartsrv
tcp        0      0 0.0.0.0:1128            0.0.0.0:*               LISTEN      2295/sapstartsrv
tcp        0      0 0.0.0.0:1129            0.0.0.0:*               LISTEN      2295/sapstartsrv
tcp        0      0 :::22                   :::*                    LISTEN      2475/sshd
tcp        0      0 ::1:25                  :::*                    LISTEN      2169/master
udp     5376      0 0.0.0.0:68              0.0.0.0:*                           1308/wickedd-dhcp4


telnet IP 31015
gives keep trying then unable to reach

telnet working for other ports like ssh and 1128 etc.

please help
0
I have a Physcial Server hoste dwitH SAP ECC and BW Modules i am looking at migrating to cloud could any please advice on the best approaches to migrate to cloud considering that time is important factor (may be a image backup and restore will work) ?.

Please advice i will give points to multiple answers every one is welcome....
0
Hi all,
i have the unenviable task of updating an onliine sales portal made at least 10 years ago, and which links into a customers SAP system.

there are no problems when i am updating prices, but if i need to add items to the page, there is code i obviously need to alter:
onClick="buyItem('5247 BURN AID GEL 50G PK10','6.10', document.itemsform.box10.value)">

The question is, what and where does the "document.itemsform.box10.value" refer to, and can i just add to the box value if i am adding more items? i.e. if box11.value didnt exist, could i add that code to a new item?

thanks in advance
0
I am unable to send the report to email ,could you please help me to fix ,if possible please explain the necessary steps to take .It's very helpful to me .
0

SAP

480

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
>