Databases

58K

Solutions

40K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

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

Sign up to Post

I had to create a new CD.mdb database due to errors in the index.
I imported all tables, forms, queries, etc. successfully.  No index error found while compacting database.

I replicated the database to three other users, while keeping the design master on my computer.

When the other users open their replica, as error appears:   Missing or broken reference to OWC10.DLL.

How can I fix this problem?

Here are 2 images:

 Image 1
Image 2
I hope to resolve this before the users return to work on Monday.

Thank you for your help!
0
I am trying to get a better understanding of what makes a SQL log file grow. For most of our clients they do not implement a point in time backup procedure so the recover model is set to Simple. Their databases tend to be fairly small(less than 10GB). I routinely perform upgrades to their ERP solution and during the upgrade process the log file may grow to 8GB due to all the insert, update and delete commands. Now sometimes a client does not upgrade at each revision so I need to perform a multi-hop upgrade to get them from the version they are on to the most current version. Now I just conducted an experiment. I just performed a four hop upgrade. At each upgrade I saw the log file grow to about 8GB. I then shrank the log file before performing the next upgrade. I then performed the complete upgrade without shrinking at each hop. I was surprise to see that the log file was about the same 8GB. Why didn't the log file grow to 32GB? Is SQL reusing some of the space in the log file?
0
Hello here,
Have a problem on an customer install, I can connect on the DB using SQLPlus, SQLDeveloper, Excel connection via ODBC and OLE DB.

But the customer can't connect to his software (that connect through Oracle Form i guess as window name is Oracle Form Runtime) and I don't know if it's possible that Form try to connect on another instance of the base or something like that. Services seem's to be all launched, TNSNames and Listener.ora seem's work as i can connect through DOS and SQLDeveloper.

Have someone an idea of what can be wrong ? And if need me to link something to help for correcct this.

Thank you.
0
I have  two fields I want to update using CASE WHEN Syntax.
The fields are PipUPC and TUPC. I don't know how to set the fields with the ELSE END syntax using the CASE WHEN.
Essentially what I need is:
1) check the PipUPC and if it is null, update  update with the List_UPC  value  from ActionList2020  table ELSE keep the  current value in the cell.
2)Check the TUPC and if null, update with the List_UPC  value  from ActionList2020  table ELSE current value of the in the cell.



Update
.[dbo].[UpdateProcessSales] 

Set PipUPC=
(

CASE WHEN PipUPC is NULL then t2.List_UPC,
 WHEN TUPC is NULL then UPC=t2.List_UPC
ELSE END,
)
from
[dbo].[UpdateProcessSales] t1
inner join
[dbo].[ActionLIst2020] t2
on t1.PNumber=t2.Price_Code

Open in new window

0
I have 3 Application Servers and One SQL Database Server. One Application server cannot connect with SQL DB.
Whereas other two Application servers are connected and working fine.
Please suggest how to troubleshoot the issue.
0
I am currently refactoring some of our old code, from Strut to Spring. It is a legacy application and some of the tables in the database don't have foreign key constraints.

ER.png
I am dealing with the above tables. A BookMarketingMedium (=a newspaper, magazine)  can have zero or more BookMarketingMediumEmails (=when we inform the newspapers that an article has been published on our website). The BookMarketingMediumEmails table does not have any foreign keys and two composite keys: bookMarketingMediumId and languageId.

To deal with the composite key, I had created an embeddable class:

BookMarketingMediumEmail.java:

@Data
@EqualsAndHashCode(of = { "email" })
@Embeddable
public class BookMarketingMediumEmail
{
    @EmbeddedId
    private BookMarketingMediumEmailIdentity bookMarketingMediumEmailIdentity;

    @NotNull
    private String subject = "";

    @Email
    @NotNull
    private String email = "";

    public BookMarketingMediumEmail(BookMarketingMediumEmailIdentity bookMarketingMediumEmailIdentity, String subject, String email)
    {
        this.bookMarketingMediumEmailIdentity = bookMarketingMediumEmailIdentity;
        this.subject = subject;
        this.email = email;
    }

}

Open in new window


BookMarketingMediumEmailIdentity.java:

@Data
@Embeddable
public class BookMarketingMediumEmailIdentity implements Serializable
{
    @NotNull
    private long bookMarketingMediumId;

    @NotNull
    private long languageId;
}

Open in new window



The problem occurs in this class

BookMarketingMedium.java:

@Data
@Entity
@Table(name = "bookMarketingMedium")
public class BookMarketingMedium
{
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int bookMarketingMediumId;

    @NotNull
    private String medium;

    @NotNull
    private String mediumNameEN;

    @NotNull
    private String mediumNameGE;

    private String mailFrom;

    @ElementCollection(fetch = FetchType.LAZY)
    @CollectionTable(name = "bookMarketingMediumEmail")
    @JoinColumns({
            @JoinColumn(name = "bookMarketingMediumId"),
            @JoinColumn(name = "languageId")
    })
    private Set<BookMarketingMediumEmail> bookMarketingEmail = new HashSet<>();

}

Open in new window


What I would like to achieve is that when I 'get' the BookMarketingMedium it should also load all the BookMarketingMediumEmails that are associated with that particular 'medium'.

Unfortunately, I get the following BeanCreatingException:


Open in new window

0
Hi,
I have e PHP (7.1) for cycle that should run through > 80000 loop, but every time it stops at the very same cycle (5884).
Basically this script fetch some content from a remote FTP, and the does lots of INSERT in mysql database.
I would like to troubleshoot this, any suggestion?
thank you very much!
0
CA SiteMinder SSO user store creation and migration from LDAP to SQL Database. User Store.
0
GRANT EXECUTE ON adminAA.* to '*'@'%';

returns error
Error Code: 1410. You are not allowed to create a user with GRANT      0.016 sec
delimiter $$

CREATE DATABASE `adminAA` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_bin */ /*!80016 DEFAULT ENCRYPTION='N' */$$
use adminAA$$
DELIMITER $$
drop function if exists afSlaveStatus$$
Create function afSlaveStatus()
RETURNS varchar(25)
begin
  Return(
   SELECT SERVICE_STATE FROM performance_schema.replication_applier_status
  );
end$$

GRANT EXECUTE ON `adminAA`.* to '*'@'%'$$

Open in new window

0
Dear ,

Im looking Discover LDAP  SQL inventory tools to pull below fields from SQL databases :

1- Server Name
2- Server IP
3- OS Version
4- SQL Version
5- Instance Name
6- DB Name
7- Database Restore Date
8- Last database access
9- Logins last access

Regards
0
I have to create a web form for 100 products and services that we have and each one has similar steps. We use Mvc 4 with c#. It has some simple workflow as well. And they will be saved into the database

Any suggestions how to get start?
0
I have this cursor inside a stored procedure. Inside this script is a call to a function called GETQUANTITY. This function exists in another database in the same instance. Now they want to move that database to another server. When I run this sp now I get this message even after adding the prefix for the linked server.
"Cannot find either column "MYDATABASE" or the user-defined function or aggregate "MYDATABASE.dbo.GETQUANTITY", or the name is ambiguous."  The purpose of this routine is to insert a purchase order. No value needs to be returned.

DECLARE po_line_cursor CURSOR
      FOR SELECT
            ISNULL(POH.VENDORID,'UNKNOWN') AS VENDORID,
            ISNULL(POH.PODATE,'01/01/1900') AS PODATE,
            ISNULL(POH.REQDATE,'01/01/1900') AS REQDATE,
            ISNULL(POH.TERMS,'UNKNOWN')  AS TERMS,
            ISNULL(POH.SHIPVIA,'UNKNOWN') AS SHIPVIA,
            ISNULL(POH.ISCLOSED,0) AS ISCLOSED,
            case WHEN VEN.VGPCODE IS NULL THEN VEN.VENDERID ELSE LTRIM(RTRIM(VEN.VGPCODE)) END AS VGPCODE,
            ISNULL(VEN.NAME,'UNKNOWN') AS VENDNAME,
            case PATINDEX('%-%',POH.PONUM) WHEN 0 THEN POH.PONUM ELSE SUBSTRING(POH.PONUM,0,PATINDEX('%-%',POH.PONUM)) end AS PONUMBER,
            case when POL.POLID IS NULL THEN 0 ELSE POL.POLID END AS POLID,
            ISNULL(POL.ITEMNUMBER,'UNKNOWN') AS ITEMNMBR,
            ISNULL(CONVERT(CHAR(100),POL.DESCRIPTION),'UNKNOWN') AS ITEMDESC,
            case when POL.UNITPRICE IS NULL THEN 0 ELSE POL.UNITPRICE END AS UNITPRICE,
            ISNULL(POL.JOBNUMBER,'UNKNOWN') AS JOBNUMBER,
            case when JOB.CONTRACTCOMPLETE IS NULL THEN 0 ELSE…
0
Sybase performance tuning .Please explain in detail the meaning of this query plan :

QUERY PLAN FOR STATEMENT 206 (at line XXX).
Optimized using Deferred Compilation.
Optimized using Serial Mode
0
Hi,
Any help to error below?

"ERROR"      1544      "2020-02-14 16:06:28.994"      "Severity: 1 (Critical), Code: HM5028, Source: ADOConnection::Connect, Description: Error when connecting to database. Microsoft OLE DB Provider for SQL Server Cannot open database "hMailserver" requested by the login. The login failed. Check your database settings in hMailServer.ini."
0
Hi,

I have a sql database in which I gather info of other sql databases and use this to do execute some actions.
F.e. I gather which applications are.deployed on sccm, AppV Infra and where they are deployed to, which users requested it etc

Therefore I query different sources  via Powershellandcreate different tables in my database (let's call it MyGatheringDB).
I.also have ssrs which does query my MyGatheringDB to show reports.

Isn't there a way I can make ssrs do the work and query ssrs right away?
In.other words, I d then query select * from sccm on ssrs and query these ssrs items (stored procedure then?) from my MyGtatheringDB without the need to store all the tables on MyGatheringDB?

Thanks
0
I am getting String was not recognize as valid DateTime when I try to upload to the database.  Any Ideas see code below..

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Net;
using System.Security.Principal;
 
namespace CertificationCapture {
    public partial class _Default : System.Web.UI.Page {
        protected void Page_Load(object sender, EventArgs e) {
            if (!IsPostBack)
            {
                Cal1.Visible = false;
                Cal_exp.Visible = false;
            }
        }
 
 
        protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
        {
            if (Cal1.Visible = false)
            {
                Cal1.Visible = true;
            }
            else
            {
                Cal1.Visible = true;
            }
        }
 
        protected void Cal1_SelectionChanged(object sender, EventArgs e)
        {
            ent_date.Text = Convert.ToString(Cal1.SelectedDate.ToString());
            Cal1.Visible = false;
        }
 
        protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
        {
            if (Cal_exp.Visible = false)
            {
                Cal_exp.Visible = true;
            }
            else
            {
                Cal_exp.Visible = true;
            }
 
        }
 
        protected void …
0
Message:No database instance is defined.  Use the Administrator application to add a new database instance., Exception: class com.primavera.ServerException
0
I have a simple question form which inserts the question into a mysql database (all on a local network).
I need the facility to print multiple copies of the question on 2 different printers instantly (or within 30 seconds of the question being entered..

Is there a way of automating this via PHP rather than relying on the client to do this?

Ideally the db will be updated once the printing has been sent.

Any ideas?
0
I am receiving an error: "Cannot open any more databases. (Error 3048)" while opening a Microsoft Access 2016 report with several fields that are lookups to different tables.

It is a survey with about 250 questions. Each question has a drop-down list that looks into a different table for the values to display.

Any help to resolve this issue would be greatly appreciated
0
Hello -

I'm new to Access and hoping someone can assist.  We use Access for a project tracking database.  Individual records have a project title.  We also use Outlook calendar to track project time.  For example, you would see an appointment from 8am - 10am for project title:  System Maintenance, which matches the project record in the database.

What I'd like to do is have a macro that the project managers could run at the end of the month that would scrub their Outlook calendar and add the project name, date, and sum of time to a table.

Is this possible?

Thanks
0
We have an old database in SQL Anywhere that contains gps positions, date and fuel purchase information, it's on a separate server on a not-supported anymore application called PCMiler Fueltax.

We're still using it since it works fine but our latest import didn't work, for reason I can't explain the system won't accept 2020 dates.

I'm at a loss trying to figure out why , the error simply says   "Invalid date ".

I use the same data, put 2019 and it works, 2020, 2021 gives me the error message so I'm thinking there's a setting somewhere that stop accepting data but ... what could it be.

If anyone has an idea or something I could try feel free to answer !

Thanks !
0
Hi there,

We have two users, each with their own copy of an Access database, which has some linked tables so that both users can see updates when the other user makes changes.  We have a form that displays entries from two of these linked tables.  For some reason, when they both try to make changes to the form at the same time, they get the attached error.  What can be changed/set up so that they can both enter new values and not get this error?

Thanks,
Christian
access-error.png
1
We use RMAN to backup our Oracle 12.1C RAC database.  We have a Solaris cron job and database backups are scheduled.  Recently RMAN backups started to just hang, just stop and not progress.  We have been scratching our heads as there doesn't appear to be anything different than we have been doing for the last year.  Any ideas, or recommendations to sort this out?
0
Need to provide our hardware group with size information for Oracle RMAN database backups.  What is a good method to determine size and growth?  We would like to keep 4 backups and have archivelog mode turned on.  Current size of database is 850 GB, e.g. total of allocated for all tablespaces.
0
I built a RedHat server in AWS that runs an application that has 3 IPs and 3 URLs (1 URL per IP), in ifcfg-eth0 I have the config listed as:

BOOTPROTO=static
DEVICE=eth0
HWADDR=06:a6:8c:d3:2c:f0
ONBOOT=yes
TYPE=Ethernet
USERCTL=no
IPADDR0=172.30.74.62
IPADDR1=172.30.74.237
IPADDR2=172.30.74.37
GATEWAY0=172.30.74.1
NETMASK=255.255.255.0

I had it working for some time, but for whatever reason I can't access the RDS database anymore, and not sure what happened to the server.

I can ping externally (google.com) but when I try to ping the RDS which is 172.30.72.x network, I get no route to host, when it used to work.  Thoughts?
0

Databases

58K

Solutions

40K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.